Forum Discussion
Unpivot columns using dax
Hi Anonymous
I believe you can refer to the UNION function:
https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax
Here're similar posts for your reference:
https://community.powerbi.com/t5/Quick-Measures-Gallery/DAX-Unpivot/td-p/574832
"My problem is I cant manipulate this in power query editor since it's not a query. "
Unless this is a live connection or Direct Query I would challenge your statement. Surely the data sources for your DAX table come from a query somewhere?
The data used in the calculations for my dax table was originally sourced from an excel model, so I dont think it is a direct query or live connection. However, my understanding is limited so not sure how to go about this other than using UNION (very tedious when unpivoting alot of columns)