Forum Discussion

SuryaK's avatar
SuryaK
Frequent Visitor
3 years ago
Solved

Slicer

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 ?
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    3 years ago

    Hi SuryaK ，

    Try to create a new column on base table:

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

    Output result:

     

     

    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Community Support
3 years ago

Hi SuryaK ，

Try to create a new column on base table:

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

Output result:

 

 

Best Regards

Lucien