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.
Hello Everyone,
Need help to convert data from column wise to row wise.
My current data set is as follows:
Column 1 | Column 2 |
Jan | 100 |
Feb | 200 |
Mar | 300 |
April | 400 |
May | 500 |
I am looking for a result as follows:
Jan | Feb | Mar | April | May |
100 | 200 | 300 | 400 | 500 |
Thanks in advance.
Best Regards,
Shib
Solved! Go to Solution.
For that, 2 steps @coolshib
Turns this:
into this:
Just make sure to set your data types when done from the 123/ABC to whatever it needs to be - whole number, number, etc.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingFor that, 2 steps @coolshib
Turns this:
into this:
Just make sure to set your data types when done from the 123/ABC to whatever it needs to be - whole number, number, etc.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingGlad to be of assistance @coolshib
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.