Forum Discussion

VGoncalves's avatar
VGoncalves
Regular Visitor
4 years ago
Solved

TotalYTD not working

Hello,   i have this measure: HIRINGS_L1Y = CALCULATE(SUM(BD_COLAB[HIRING]), DATESINPERIOD(DIM_DATES[Date], MAX(DIM_DATES[Date]), -13, MONTH))   This measure will give me, for example, for fe...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

  • VGoncalves's avatar
    VGoncalves
    Regular Visitor
    4 years ago

    @amitchandak  i run again the measure, and still doesnt work, but the numbers arent that off. For jan'22 i have 378 hirings and for feb'22 i have 399 hirings, should give me a YTD of 777 hirings, but using your measure will give me 798 hirings.. its not that off, but isnt right

  • VGoncalves's avatar
    VGoncalves
    Regular Visitor
    4 years ago

    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!!