Create a matrix table with different periods.

[jerpic]

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.

[Anonymous]

Hi @jerpic,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng