Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |