Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
6 years ago

Transform a summarised table

I've created a table by summarising my main table using the formula below.

 

SummarisedTable = SUMMARIZE('Table','Table'[ Column1],'Table'[Colum2],'Table'[Column3],'Table'[Column4],'Table'[Column5])
 
Is it then possible for me to transform this summarised table? In my case, I want to transpose the data such that the column headings become my row values. (https://community.powerbi.com/t5/Desktop/Transpose-table-titles-from-columns-to-rows/m-p/447653#M207133)
 
I don't want to do anything to the main table as I need it in its original format, hence why I've created the summarised table. I want to be apply filters on the main table such that the values in the summarised table update accordingly.
 
Not sure if this is possible?
Need Help

5 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi bo_afk ,

     

    Rather then creating summarised table using DAX, you can do same in Edit Query:

    1. Create a summarised table from main table using GROUP BY in "Edit Query"

    2. Transpose this summarised table as required.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

    • bo_afk's avatar
      bo_afk
      Post Patron
      6 years ago

      Pragati11 thanks for your response. Seems like it could work in my case. Is the new summarised table still linked to the original? If I filter from the original table, do the values change accordingly in the summarised table?

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi bo_afk ,

         

        Just create relationship between your summarised table ans original table on a key column. Once that is done, it will get filtered properly.

         

        If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

         

        Thanks,

        Pragati

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi bo_afk 

     

    If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!