More one click transforms to come.. 25 New Transforms Remove Blanks via Remove all rows where value for current column is null or empty. Mar-2016 Column Filter Accessible via Column Filter menu dropdown Convert duration to Years Duration to Divide # of days of duration type column by 365 Keep Duplicates Available in Transfor or Add tab Keep duplicates keep only rows with duplicated values on selected columns – Available on Home tab under Remove Duplicates split button 26 Preview: View tab Mar-2016 – whitespace and “Show line feeds in whitespace” Query Editor (now default) – preview in Query Editor Window 27 Option to disable Reduces the # of Mar-2016 preview from calls being made to Navigator the data source to retrieve previews
More one click transforms to come.. 25 New Transforms Remove Blanks via Column Filter Convert duration to Years Keep Duplicates Remove all rows where value for current column is null or empty. Accessible via Column Filter menu dropdown Duration to Divide # of days of duration type column by 365 Available in Transfor or Add tab Keep duplicates – keep only rows with duplicated values on selected columns Available on Home tab under Remove Duplicates split button Mar-2016 26 Preview: whitespace and line feeds in Query Editor preview View tab – “Show whitespace” (now default) – in Query Editor Window Mar-2016 27 Option to disable preview from Navigator Reduces the # of calls being made to the data source to retrieve previews Mar-2016
pbi-desktop-data-transformation-features.docx