Forum Discussion

jerpic's avatar
jerpic
Frequent Visitor
4 years ago

Create a matrix table with different periods.

Hello,

 

I would like to create a matrix table with 3 different periods (M, M-1, N-1) per Row (J and W), like this sample.

 

 

Where M is the current month, M-1 is the previous month and N-1 is the same month last year.

 

For information, I'm able to calculate Measure 1 (M, M-1, N-1) with this kind of calculations (I have a Time table in my model)  : 

 

Measure 1 (M-1) = CALCULATE(SUM('data'[Measure1]),PREVIOUSMONTH('DATE'[Date]))


Measure 2 (M-1) = CALCULATE(SUM('data'[Measure2]),PREVIOUSMONTH('DATE'[Date]))


But with this logic the renderer is different....

 

 

Small precision, in order to select the current year and month I have 2 segments on top of my dashboard, like that: 

 

 

Any help will be very much appreciated.

 

Best Regards,

Jérôme.

 

1 Reply