Slicer

[SuryaK]

I have two slicers one is month filter another one is no of month filter .if I select month filter march-22 and select no of month -2.I need jan-22,feb-22 in slicer.how to calculate ?

[v-luwang-msft · Accepted solution]

Hi @SuryaK ，

Try to create a new column on base table:

Month = MONTH('Date'[Date])-1

Output result:

Best Regards

Lucien