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 (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

Need Help

4 Replies

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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'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