Year on Year Difference Problems

[EpicTriffid]

Hi there, 

I've been working on this problem for a while now, and when I think its solved, it turns out its not.

I'm trying to show Year on Year Differences. You can see above, however, that while the Last Year is right between 15/16 and 16/17, the one between 2016/17 isn't right. I can't work out why. That then expands the problem by throwing off the Vs Last Year measure. 

I've been trying to fix the Last Year measure but can't. I've tried using SAMEPERIODLASTYEAR and PARALLELPERIOD but they often give me % in the hundreds. So I'm currently using the below for the Last Year:

Last Year = CALCULATE(SUM(KPIs_COMBINED_RESHAPED[Actuals]),FILTER(ALL('Date'), 'Date'[Year Number] = MIN('Date'[Year Number])-1)) 

That gives me the figures you see above. "Year Number" is just an indexing system of my academic years. 

Any insight? 

[EpicTriffid]

Hi @kentyler ,

The data is already set up with the Years stacked. 

Hi @VipulToshniwal ,

I have tried SAMPERIODLASTYEAR but it just comes up with the same result. 

[dax]

Hi EpicTriffid,

Could you please tell us if your question has been resolved. If so, in order to close the thread, please kindly mark helpful replies as answers. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

If it didn't solve your problem, you could try to inform me more details information(such as your sample data), then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

@EpicTriffid 

Have you tried DATEADD? something along the lines of:
Measure for last year = CALCULATE([Measure], DATEADD(date[date], -1, YEAR))

[VipulToshniwal]

Hi @EpicTriffid ,

Have you looked at the SAMEPERIODLASTYEAR function? Build a DAX around it. Here is the like to the documentation. 

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

Please, let me know if the DAX with this function works for you.!

Regards,

Vipul 

[kentyler]

Your measure refers to a single date field, yet your data has multiple columns, each of which refer to different dates.
Maybe try unpivoting your data so you have the years stacked on top of each other instead of side by side (you will have to add a "year" column) and see if that changes the behavior of your measure.