I have month level granularity data and want to compare the most recent June to the previous June. The date is different from 2019 to 2020.
Any ideas how I might achieve this?
Any ideas what function I should be looking at?
I have looked at so many functions and maybe its the end of the week, but I am having no luck.
In english like code, I suppose I want (even though there is only one value as it is month level data), I want to SUM the Data[Value] for the MAX June month in my date calendar.
After that I can use SAMEPERIODLASTYEAR, or DATEADD, and things like that to compare to 2019.
Any guidance most appreciated.