Dax Variance calculation between prior and current year

@ambidextrousmentally,

@DaveC is spot on that the granularity of your data does not allow you to do this. However if you were to make some assumptions regarding daily sales, you could convert the annual granularity to an estimated daily granularity that would allow you to do this calculation.

If I were going to go that route, I would do it in Power Query. This exact issue was the focus of Problem of the Week #4. Here’s the thread for that problem, where Enterprise DNA Expert @haroonali1000 explains the problem and the solution.

You could also do it in DAX. Here’s a video from @sam.mckay that provides an excellent approach to accomplishing it that way.

https://forum.enterprisedna.co/t/the-ultimate-budget-allocation-methodology-for-power-bi-analysis/4069

I hope this is helpful.

– Brian