topic Re: Comparing year over year differences using datesbetween in DAX Commands and Tips

Comparing year over year differences using datesbetween

abeirne — Mon, 25 Jul 2022 16:12:29 GMT

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

)

Re: Comparing year over year differences using datesbetween

amitchandak — Mon, 25 Jul 2022 18:06:54 GMT

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-654f26e27304

Re: Comparing year over year differences using datesbetween

abeirne — Mon, 25 Jul 2022 18:22:06 GMT

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!