Transform a summarised table

[bo_afk]

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#M207...)

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?

[v-diye-msft]

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!

[amitchandak]

Refer : https://radacad.com/pivot-and-unpivot-with-power-bi

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Pragati11]

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]

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

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