Difference between 2 dated values

[nzboan]

I want to calculate the difference in % between two dated values, like in this example:

January 2016: 10

January 2017: 11

%diff: +10%

This is what i've managed to do until now: 

[v-ljerr-msft]

Hi @nzboan,

Have you tried the solution provided by @Anonymous above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here. 

Regards

[Anonymous · Accepted solution]

Hi,

If I understand you correctly, you can use SAMEPERIODLASTYEAR(). 

Amount (same time last year)

= CALCULATE(
SUM(FactInternetSales[SalesAmount]),

SAMEPERIODLASTYEAR(OrderDate[FullDateAlternateKey]),

ALL(OrderDate)

)

For example, this should give you:

Order Date (Year)          Sale Amount         Calc Sale Amount Same Last Year         
2016                                       10
2017                                       11                          10

From there, you should be able to calculate %diff.

There's a good article about Time Intelligence function, including SAMEPERIODLASTYEAR() - http://radacad.com/secret-of-

time-intelligence-functions-in-power-bi

Hope this helps.