Forum Discussion
Creating a new table with rows split by a new value
Hi, I am quite new to Power BI. I have a table (direct query) with 3 columns Date - Male_KPI - Female_KPI 23/5/2019 - 8000 - 7000 22/5/2019 - 7000 - 8000 I need a new table with this structu...
if it wasn't Direct Query my guess would be to use unpivot in the Query Editor - but I guess it switches the table to Import mode, correct?
Otherwise I guess you can do it in DAX using UNION and SELECTCOLUMNS
https://dax.guide/union/
https://dax.guide/selectcolumns/
But I guess the most efficent performance wise would be creating the view in your database