Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
Kind of new to the power query/pbi here, hope its an easy questions
Please see below screenshot
How to convert from the data set on the left to the data set on the right? In either power query/query editor
The data on the right repeat in that arrangement
I assume its a custom column function?
Thanks Heaps
Wendy
Solved! Go to Solution.
Download my attached workbook to see what I did.
Essentially I:
End result - Blue table is before, green table after:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingDownload my attached workbook to see what I did.
Essentially I:
End result - Blue table is before, green table after:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingGreat! Fill Up/Down is a really useful transformation when you have a report you are trying to convert to a useful table.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.