Frequent Visitor
Posts: 30
Registered: ‎07-12-2017

Unpivot Dax code neede

Hello Team,

       i want to unpivot my table by DAX code only because i am unable open Query editor for that table. Basically one table is coming from SQL Server and again added some columns by ADDCOLUMNS in code and loaded in other table which i told before. So when i try to Edit query for latest table with added columns it doesn't show Edit Query for Unpivot other columns. so only i have option using DAX i need to Unpivot that table. any body has refernce code or suggestions  please.

Posts: 9,740
Registered: ‎03-06-2016

Re: Unpivot Dax code neede

Hi @sampathkumar,


You can refer to these two threads:


If it doesn't meet your requirement, please share your pbix file and clarify corresponding desired results. 


Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.