Unpivot Dax code neede

[sampathkumar]

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.

[v-qiuyu-msft]

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