Forum Discussion
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 ?
Hi SuryaK ，
Try to create a new column on base table:
Month = MONTH('Date'[Date])-1Output result:
Best Regards
Lucien
1 Reply
Hi SuryaK ，
Try to create a new column on base table:
Month = MONTH('Date'[Date])-1Output result:
Best Regards
Lucien