October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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 ?
Solved! Go to Solution.
Hi @SuryaK ,
Try to create a new column on base table:
Month = MONTH('Date'[Date])-1
Output result:
Best Regards
Lucien
Hi @SuryaK ,
Try to create a new column on base table:
Month = MONTH('Date'[Date])-1
Output result:
Best Regards
Lucien
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |