Comparing year over year differences using datesbetween

[abeirne]

Hi all, I am using two measures that calculate revenue as of today. I have one for the current year and one for the prior year. These measures allow me to compare the reservation amounts as of today vs today last year. 

I am trying to find the year over year difference between the two, but I can't just subract them since the numbers are attached to the unique dates. Could anyone help with this? Thank you so much. Here are my measures:

YTD Current Year =

CALCULATE(

    MeasureTableQ[Reservation Charges SUM],

    DATESBETWEEN(

        'Rent-Roll-Report-2021-01-01-2023-12-31'[Origination Date],

        DATE(YEAR(TODAY()), "1", "1"),

        TODAY()

        )

)

YTD Prior Year =

CALCULATE(

    MeasureTableQ[Reservation Charges SUM],

    DATESBETWEEN(

        'Rent-Roll-Report-2021-01-01-2023-12-31'[Origination Date],

        DATE(YEAR(TODAY())-1, "1", "1"),

        DATE(

            YEAR(TODAY())-1,

            MONTH(TODAY()),

            DAY(TODAY())

        )

    )

)

[abeirne]

Thank you! Also what i did was just make both of my measures into variables and returned both of them so that they are in one measure, then I was able to compare. Thanks!

[amitchandak · Accepted solution]

@abeirne , best in such case to use date table

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

LYTD Today =
var _today = TODAY()
var _max = date(year(_today)-1, month(_today), day(_today))
var _min = eomonth(_max,-1*month(_max))+1
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

refer: https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27...