Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
8 years ago

Difference of values between two dates

If I have a finished report, that is showing the country totals for 2016 and 2017 - is there an easy way to calcuate the difference (increase sum) between the two?   The source table is a list of a...
Need Help
JoHo_BI's avatar
JoHo_BI
Icon for Responsive Resident rankResponsive Resident
8 years ago

Hi Unicorn, 

 

Try this:

Measure = CALCULATE(SUM(Table1[Value]),Year(Table1[Date]) = YEAR(TODAY())) - CALCULATE(SUM(Table1[Value]),Year(Table1[Date]) = (YEAR(TODAY()) - 1))

Changing the table/column names to your need. 

 

This example keeps it dynamic too, looking at the year of today and always getting last year. You can always change these values to hard code them in. 

 

Hope that helps!

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
8 years ago

Thank you so much!  I'm going to try that tomorrow and let you know.  That looks exactly like what I'm looking for.