Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Pivot a summarized table with DAX

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 4845...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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
)

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
amitchandak
Super User
6 years ago

Anonymous , Thanks for sharing. Kudos!!