Forum Discussion
Measure to get previous month data
I have a query could you pls help me to get this sorted. Have a slicer where it contains month as 22-08, 22-09, 22-10, 22-11, 22-12. Based on the slicer value selection I have to always get previous ...
Ok got it thanks.
The measure which I used to get previous month data doesnt show correct data. Could you pls help me on this.
Measure used -
CALCULATE(COUNT(NGRReport[reportid]), PREVIOUSMONTH(NGRReport[Date]))
ForNov -
ForNov -
Supposed to get 63 in place of 10 here
I have Date table as well in model & connected.
Slicer created on is date column from NGRReport
Change your PREVIOUSMONTH function to use the date from the calendar table.