Forum Discussion
Unpivot with Direct Query
Hi, Is it possible to UNPIVOT the data by using the Direct query in Power BI Desktop? Thank you,
Here is a post suggesting a work around using UNION()
https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax
Is the "Unpivot Column" button grayed out ? If so you will have to do the unpivot in the datasource.
Here is a post suggesting a work around using UNION()
https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax
kentyler , Brilliant, It works for me with Union. Thank you
hi
can you post your Advanced editor script because ii try thie solution but i dont understand because i get some error
thx
