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.
Hi all,
I have a table like the one bellow:
Name From To
A 201701 201706
B 201711 201803
Using Power BI querry I would like to transform it to:
Values on columns "From" and "To" represent months formatted as YYYYMM
Name Month
A 201701
A 201702
A 201703
A 201704
A 201705
A 201706
B 201711
B 201712
B 201801
B 201802
B 201803
Thanks
Hi emilmaican,
I'm afraid power query can't complete the continuous date automatically. As a workaround, you can click query editor-> transform-> click on column [From] and [To]-> click Unpivot Columns, the result is like below:
Regards,
Jimmy Tao
Covering 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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |