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