Forum Discussion
Solved
Using dax to unpivot a table
Hi all, I need to unpivot a table. The challenge here is we are using ssas tabular model so I can not just select the target columns and unpivot under "edit query" mode. The table is like the fo...
Same issue I have.
Somce one suggested UNION function for a question on another website - StackOverFlow
https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax
See, If this helps :-)
Hi rawmeat,
Are you using live connection mode or import mode? If you are using live connection mode, you can't do changed in your data model so that the "Unpivot Column" is grey and you should do Unpivot operation in your SSAS model. If you are using import mode, you can Unpivot your column by clicking Transform-> Unpivot Column.
Hope it's helpful for you.
Regards,
Jimmy Tao
Yes the issue here is I am using ssas direct query mode so I can't use edit query option in power bi desktop.