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

     

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity 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