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.
Please advise how to convert below in PowerBI desktop
Date | A | B | C |
4/1/2020 | 230 | 392 | 392 |
4/2/2020 | 390 | 44 | 454 |
4/3/2020 | 550 | 392 | 454 |
4/4/2020 | 710 | 546 | 5645 |
4/5/2020 | 870 | 392 | 454 |
4/6/2020 | 1030 | 574 | 448 |
4/7/2020 | 1190 | 392 | 454 |
4/8/2020 | 1350 | 474 | 454 |
into something like below
Header | Header | Values |
4/1/2020 | A | 230 |
4/2/2020 | A | 390 |
4/3/2020 | A | 550 |
4/4/2020 | A | 710 |
4/5/2020 | A | 870 |
4/6/2020 | A | 1030 |
4/7/2020 | A | 1190 |
4/8/2020 | A | 1350 |
4/1/2020 | B | 392 |
4/2/2020 | B | 44 |
4/3/2020 | B | 392 |
4/4/2020 | B | 546 |
4/5/2020 | B | 392 |
4/6/2020 | B | 574 |
4/7/2020 | B | 392 |
4/8/2020 | B | 474 |
4/1/2020 | C | 392 |
4/2/2020 | C | 454 |
4/3/2020 | C | 454 |
4/4/2020 | C | 5645 |
4/5/2020 | C | 454 |
4/6/2020 | C | 448 |
4/7/2020 | C | 454 |
4/8/2020 | C | 454 |
Solved! Go to Solution.
In Power Query, select the date column, then on the Transformation ribbon, select "Unpivot Other Columns."
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIn Power Query, select the date column, then on the Transformation ribbon, select "Unpivot Other Columns."
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you for quick reply
Glad to help @dhirendra59
Mark it as a solution if it has answered the question so others know this is the solution if they are looking later.
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.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |