Solved: Transpose

Anonymous · ‎05-28-2021

Hi,

I searched how to transpose column and row but I didn't find. Can anyone know how to do it?

I saw an old post on this forum about it but the solution don't work for me.

Indeed my column are calculated column so I can't use power query.

I put a screen of the old topic it will help you understand what I would like to have.

Thank you

Best regards

Fowmy · ‎05-28-2021

@Anonymous

You should reconsider those columns to be created in PQ or try to achieve your results using Measure.

But, Unpivoting is possible though:
https://www.youtube.com/watch?v=9Xv8COs59tc

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

Fowmy · ‎05-28-2021

@Anonymous

You should reconsider those columns to be created in PQ or try to achieve your results using Measure.

But, Unpivoting is possible though:
https://www.youtube.com/watch?v=9Xv8COs59tc

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group