A more complicated table transformation using querry

[emilmaican]

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 

[v-yuta-msft]

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