Unpivot data in Power bi

[lilySixteen]

Hello Community,

I have below table, can you please advise how to unpivot it to get a new table that has a "Month" Column (contains April, May and June),  a "Billings" Column, "Outstanding AR" Column, and a "Collections" Column?

Thanks so much!

Lili

[camargos88]

Hi @lilySixteen ,

Can you post the data as text? So we can copy it.

[lilySixteen]

@camargos88 Here is the data. Thanks!

https://drive.google.com/file/d/1ymppGXXqHm-TiHbg_ytxAn--rRktlaNe/view?usp=sharing 

[camargos88]

@lilySixteen ,

I've requested access to this file.

[lilySixteen]

@camargos88 Thank you for your help! I was able to figure it out using the supporting links provided by amitchandak, so I'm good now. Thanks!

[amitchandak · Accepted solution]

@lilySixteen , You can have one level of unpivoting , I doubt you can have two level

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

You may need unpivot-twice

https://kohera.be/blog/power-bi/how-to-unpivot-twice/

[lilySixteen]

@amitchandak Thanks so much for providing these links! They are very helpful, and I was able to figure it out by following the steps provided in the 3rd link. Thanks again!