compare KPI to the last year end of year

[Pbiuserr]

Hello,

I want to compare KPI from given period to last year - end of the year. So for instance on slicer I got May 2022, it shows me lets say Sales Amount and I want to compare it to the last year (so May 2021) but shifted to December 2021

I guess its going to be mix of dateadd and endofyear functions? Can anybody help me with that?

[amitchandak]

@Pbiuserr , refer these measures based on today

using TI, selection of date is needed

last year last month = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1*month(Today()),MONTH)))

No date selection needed

This Month Today =
var _min = eomonth(today(),-1)+1
var _max = eomonth(today(),0)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Last Month Today =
var _min = eomonth(today(),-2)+1
var _max = eomonth(today(),-1)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Same Month Last Year Today =
var _min = eomonth(today(),-13)+1
var _max = eomonth(today(),-12)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Last Month Last year Today =
var _min = eomonth(today(),-1*month(Today())-1)+1
var _max = eomonth(today(),-1*month(Today()))
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

[Pbiuserr]

I don't understand them

I want to compare value from user slicer selection (let it be April 2022) to December 2021
then (Value April 2022 - Value December 2021)/Value Dec 2021 in another measure

, then user selects June 2021 and it compares value to December 2020

then (Value June 2021 - Value December 2020)/Value Dec 2020 in another measure

does this measure solve that?

[Pbiuserr · Accepted solution]

Okay, my solution is:

VAR _endofyeardate = MAXX('Calendar',ENDOFYEAR(dateadd('Calendar'[Date],-12,MONTH)))

RETURN

Calculate([Measure], 'Calendar'[Date] = _endofyeardate)