Recursivity Month

[Anonymous]

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
1005	03-2019	0
1002	02-2020	3
1000	01-2021	5	should be 2 : comapring to last month and not the Max Month

I need to find 0 then 3 then 2 and not 5 !!!
a recursive way !

Any help will be appericated 

[ryan_mayu]

@Anonymous 

you need to have a date column.

Column = 
VAR _next=MAXX(FILTER('Table','Table'[Month Year]<EARLIER('Table'[Month Year])),'Table'[Month Year])
var _nextvalue=maxx(FILTER('Table','Table'[Month Year]=_next),'Table'[Count tickets])
return if(ISBLANK(_nextvalue),0,_nextvalue-'Table'[Count tickets])

pls see the attachment below

[Anonymous · Accepted solution]

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]))

[amitchandak]

@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] )

[Anonymous]

Hello,
Thank you for your reply

I tried it but not working I have an error 😞

Have you an Idea please?