Forum Discussion
Unpivot with Direct Query
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
kentyler , Thanks for your response, The Unpivot option is not grayed out but it is not letting me apply changes on the Query editor window. I guess, it is not possible at the moment and I may need to Unpivot on the source side.
