Pivot a summarized table with DAX

[Anonymous]

I have a summarized table that looks like this:

I want to pivot it to a new table that looks like following for current month = 1 

metrics	values
New MRR	456564
Expansion MRR	48456
Contraction MRR	4545
Churned MRR	67878
last month mrr	124545
Total MRR	457575

I can't use the pivot function in query editor because this is a summarized table.

And I need the results in a new table for a waterfall chart.

How can I do this?

[Anonymous · Accepted solution]

I made it work by using Selectcolumns

Pivot MRR = FILTER(
                UNION(
                    SELECTCOLUMNS(MRRWaterFall,"current",MRRWaterFall[current month],"Metrics","Beginning MRR","Values",MRRWaterFall[last month mrr]),
                    SELECTCOLUMNS(MRRWaterFall,"current",MRRWaterFall[current month],"Metrics","New MRR","Values",MRRWaterFall[New MRR]),
                    SELECTCOLUMNS(MRRWaterFall,"current",MRRWaterFall[current month],"Metrics","Expansion MRR","Values",MRRWaterFall[Expansion MRR]),
                    SELECTCOLUMNS(MRRWaterFall,"current",MRRWaterFall[current month],"Metrics","Contraction MRR","Values",MRRWaterFall[Contraction MRR]),
                    SELECTCOLUMNS(MRRWaterFall,"current",MRRWaterFall[current month],"Metrics","Churned MRR","Values",MRRWaterFall[Churned MRR])
                    ),[current]=1
)

[amitchandak]

@Anonymous , Thanks for sharing. Kudos!!

[amitchandak]

If you want to display measure on row. Matrix has a property show on row. Use that.

[Anonymous]

Hi @amitchandak I don't want to display these values. I need to use them for a waterfall chart.

Apologies if I wasn't clear in the post. I've edited it to reflect my requirements more clearly.