Forum Discussion
Recursivity Month
Hello All, I need your help concerning an issue, I have a total by month and I need to compare new tickets for each month here below an exemple : Count tickets Month Year Difference ...
Yes thanks, I found it, I need a calendar table and this is the measure :
NBR-1 = CALCULATE([NBR],
KEEPFILTERS('Calendar'[Date]))-
CALCULATE([NBR],
PREVIOUSMONTH('Calendar'[Date]))
Anonymous , You need a month year in YYYYMM format first
new columns
Month Year 1= right([Month Year],4) & left([Month Year],2)
now create a column
new column =
var _max = maxx(filter(Table, [Month Year 1] <earlier([Month Year 1]) ),[Month Year 1])
return
[Count Ticket] -maxx(filter(Table, [Month Year 1] =_max ),[Count Ticket] )
Hello,
Thank you for your reply
I tried it but not working I have an error 😞
Have you an Idea please?