Forum Discussion
Row to cols (row2col)
Helllo, May somone can help me. I havee one Tabele "Umlage" this will have n rows (for each month one row) in this screenshot n=2 I need the generated Tabel "Buchungen" starting with a UID (...
v-qiuyu-msft
Community Support
Community SupportHi FlyHigh,
DAX doesn't provide the Pivot or Unpivot features. In your scenario, please try to change the KTC-Umlage_Euro, 1TC-SI, 1TC-DEV DAX to the Power Query, then use the "Unpivot other columns" feature suggested by dkay84_PowerBI.
You can use the Group By to get count value, and Merge Queries to get related columns from other table. See:
Common query tasks in Power BI Desktop
Shape and combine data in Power BI Desktop
Best Regards,
Qiuyun Yu
So if I’m right there isn't any possibility to use DAX Tables in the query editor. Or to write the dax query after all to a database?
Best regards
Peter