51 Merge Date and Select both columns June-2016 Time columns and click “Combine into a DateTime Date and Time” column Use Date or Time dropdown menu Available in Transform and Add Colum 52 Extract Start or Use the Time June-2016 End of an Hour dropdown based on a Hour Date/Time or a Available for both Time column Transform and Add Column 53 Use R Scripts Use R script to Run R Script from the Transform tab in Query Editor July-2016 inside the Query perform cleansing, Editor shaping, and analytics (predictions, clustering, etc) Need to have R installed locally Need to change privacy setting to public for source using R script
51 Merge Date and Time columns into a DateTime column Select both columns and click “Combine Date and Time” Use Date or Time dropdown menu Available in Transform and Add Colum June-2016 52 Extract Start or End of an Hour based on a Date/Time or a Time column Use the Time dropdown Hour Available for both Transform and Add Column June-2016 53 Use R Scripts inside the Query Editor Use R script to perform cleansing, shaping, and analytics (predictions, clustering, etc) Need to have R installed locally Need to change privacy setting to public for source using R script Run R Script from the Transform tab in Query Editor July-2016
pbi-desktop-data-transformation-features.docx