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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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))

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

johnt75 thanks for the suggestion, I couldn't make it work like this. 

amitchandak this one did it for me. It was a clever and simple way to solve it.
Thanks a lot both of you!