topic Re: Subtracting between measurements in DAX Commands and Tips

Subtracting between measurements

dannyd — Thu, 16 Jan 2020 14:06:56 GMT

Hi,

I'm struggling with this case for quite some time now, hopefully this community got some tricks up their sleves...

So what i wanna do is calculate the savings by subtracting the price year 2 from the price year 1 and multiplying it with the current years bookings.

Another thing that might be good to know is that the prices from year 1 and 2 are measures in the same table.

Thanks for any support!

Re: Subtracting between measurements

Anonymous — Thu, 16 Jan 2020 14:20:31 GMT

final =

var sub=[price1]-[price2]

Return

[Count of booking]*Sub

Thanks,

Pravin Wattamwar

If it resolves your problem mark it as solution and give kudos.

Re: Subtracting between measurements

dannyd — Thu, 16 Jan 2020 14:44:14 GMT

Thanks for the quick answer Pravin!

What i was not to clear about was that the measures price1 and price2 are the same. Is it perhaps possible to add a filter to your code?

Thanks

Re: Subtracting between measurements

az38 — Sat, 18 Jan 2020 15:23:21 GMT

Hi dannyd

try to

Measure = var _year1 = 2018 var _year2 = 2019 RETURN (CALCULATE([price]; YEAR('Table'[Date])=_year1) - CALCULATE([price]; YEAR('Table'[Date])=_year2)) * CALCULATE(Count('Table'[Booking]))

do not hesitate to give a kudo to useful posts and mark solutions as solution