Forum Discussion

setis's avatar
setis
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Compare volume to constant year

I'm trying to compare our Nr of cases to the volume we had in 2019. In order to do a day to day and MTD comparison, I need to place the measure in a table like this, using 'Date'[Date] from my Can...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    setis , Check suggestion from johnt75 .

     

    Please check if this can help


    NrCases_2019 =
    var _max = maxx(allselected('Date'), 'Date'[Date])
    var _year = 2019- Year(_max)
    return CALCULATE (
    [NrCases], dateadd('Date'[Date], _year, year))

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

Change the ALL line in your filter to be

ALL('Date'),

There may be filters being applied to other columns than the ones you specified, e.g. a sort column used by [Month].