Forum Discussion
Solved
Power BI- Pivot Data
Dataset ID Date1_Min Date1_max Date2_Min Date2_max Date3_Min Date3_max Date4_Min Date4_max 1 05/04/2020 14/05/2023 04/05/2021 16/05/2022 17/11/202...
Hi obriaincian , is possible in Power Query, follow this steps:
1.- Select column "Identification" and select Unpivot other columns:
2.- Select Column "Atributo" and split by delimiter: "_", like image:
3.- Select Group by, and select option and fields like the image:
"Valor column" is the column of the dates
4.- The result:
Best regards
Hi obriaincian , is possible in Power Query, follow this steps:
1.- Select column "Identification" and select Unpivot other columns:
2.- Select Column "Atributo" and split by delimiter: "_", like image:
3.- Select Group by, and select option and fields like the image:
"Valor column" is the column of the dates
4.- The result:
Best regards