Reply
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.

Highlighted
Moderator
Posts: 9,457
Registered: ‎03-06-2016

Re: Unpivot Dax code neede

Hi @sampathkumar,

 

You can refer to these two threads: 

https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax

https://community.powerbi.com/t5/Desktop/Columns-to-Rows/td-p/136649

 

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.