Row to cols (row2col)

[FlyHigh]

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 (should be an intager)

and 10 rows each Periode.

For better understanding i have added a screenshot.

My Question : How can i calculate the tabele "Buchungen" in PowerBI Desktop by given Tabel Umlage with multible rows (in this example rows =2)

 Best regards Peter

[dkay84_PowerBI]

You can unpivot your first table (right click the Periode column and select "Unpivot other Columns" in the Query Editor) then add an index column for your UID.

[FlyHigh]

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]

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]

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