Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 Reporting