Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ReportingUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |