Forum Discussion

pranesh246's avatar
pranesh246
Frequent Visitor
5 years ago

Adding multiple columns in matrix view

  I need to create a matrix table like below. I have metrics 1,2,3 and Week field with all the weeks. How do I separate into the current, prior week etc and get MoM, YoY, WoW in the same matrix? Thi...
Need Help
Show and Tell
pranesh246's avatar
pranesh246
Frequent Visitor
5 years ago

Hi Carmichael

The ones in the first column are different measures. I need values in the corresponding cells based on row measure and column measure.

 Current week(Measure)Prior week(Measure)Same week last month(Measure)Same week last year(Measure)Month on Month(Measure)Year on Year(Measure)Week on week(Measure)
Sales (Measure)       
Profit(Measure)       

 

Carmichael's avatar
Carmichael
Advocate III
5 years ago

Ah - ok....so Measures in both Rows and Columns.  Thanks for clarification and for updating your question to make that clear to others.

 

I would be trying to find a way to get the row measures into calculated columns but that purley because of I have no answer for rows in both Columns and Rows. 

 

I am interested in learning/understanding this myself so I did a quick search and found a few answers all using some variant of switch.   The following post has a solution using calculated tables (Cross Join on second solution).  Hopefully it might give you an idea to further research. 

 

Please post back here if you do get a slution working for you. 

 

https://community.powerbi.com/t5/Desktop/Table-with-multiple-measures/td-p/1047793