Creating a new table with rows split by a new value

[Anonymous]

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 structure

Date - Gender(M/F) - KPI

23/5/2019 - M- 8000

23/5/2019 - F - 7000

22/5/2019 - M- 7000

22/5/2019 - F - 8000

where the gender is M or F.

How to do that?

Roberto

[Stachu]

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