Forum Discussion
TotalYTD not working
VGoncalves , try like
HIRINGS_L1Y =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = eomonth(_max,-1*MONTH(_max))+1
return
CALCULATE(Sumx(Values(DIM_DATES[Month Year]),
CALCULATE(SUM(BD_COLAB[HIRING]), DATESINPERIOD(DIM_DATES[Date], MAX(DIM_DATES[Date]), -13, MONTH))),DATESBETWEEN('Date'[Date],_min,_max))
Super UserVGoncalves , try like
HIRINGS_L1Y =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = eomonth(_max,-1*MONTH(_max))+1
return
CALCULATE(Sumx(Values(DIM_DATES[Month Year]),
CALCULATE(SUM(BD_COLAB[HIRING]), DATESINPERIOD(DIM_DATES[Date], MAX(DIM_DATES[Date]), -13, MONTH))),DATESBETWEEN('Date'[Date],_min,_max))
amitchandak i was able to solve the difference of numbers, i did a separate measure for the ytd. thank you so much for your help!!