Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show Table Columns as Row

Hi All, Seeking you help on my issue. I have a this table below which has a column that I need to convert as rows Branch Year Month Total Product Total Sales House Loan Car Loan Preferred...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Just follow the formula in the article and create the following calculation table

    Table1 = 
FILTER(
    UNION(
        SELECTCOLUMNS('Table',"Branch",[Branch],"Year",[Year],"Month",[Month],"Total Product",[Total Product],"Total Sales",[Total Sales],"Key Drivers",[Column]),
        SELECTCOLUMNS('Table',"Branch",[Branch],"Year",[Year],"Month",[Month],"Total Product",[Total Product],"Total Sales",[Total Sales],"Key Drivers",[Column 2]),
        SELECTCOLUMNS('Table',"Branch",[Branch],"Year",[Year],"Month",[Month],"Total Product",[Total Product],"Total Sales",[Total Sales],"Key Drivers",[Column 3])

    ),
    [Key Drivers]<>"")

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

thank you for your response, unfortunately the 3 columns are not available (visible) in the power query editor.