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 | |
| 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
4 Replies
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
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
