Forum Discussion

FlyHigh's avatar
FlyHigh
Regular Visitor
9 years ago

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 (...
Need Help
FlyHigh's avatar
FlyHigh
Regular Visitor
9 years ago

Hello dkay84,

 

Sorry this isn't possible because this aren’t tables from a query.

This tables are generated so they aren’t in the query editor. (or how is this posible ?)

 

KTC-Umlage_Euro = DISTINCT('KTC-Periode'[Periode])
1TC-SI = ((RELATED('KTC-Umlage_Faktor'[1TC-SI]))*[UmlagePeriode])
1TC-DEV = ((RELATED('KTC-Umlage_Faktor'[1TC-DEV]))*[UmlagePeriode])

and so on …

 

Problem still exist ...

best regards

FlyHigh

 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi 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

  • FlyHigh's avatar
    FlyHigh
    Regular Visitor
    9 years ago

    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