I am having issues trying to calculate a value from the previous fiscal year.
The data is a little odd in that last years data is provided at a quarterly level of granularity and this years is monthly.
So the initial calculation takes this into account, and seems to be working fine, but I am having issues with the calculation for the previous financial year. But feel I need an ALL on the filter to change the filter context and bring back the entire data calendar. If using FILTER( ALL( is correct, the syntax is killing me.
I have attached the pbix for download.
Any help would be greatly appreciated.
@BrianJ, it is similar to the one you solved for me, I have tried my best,
Update: I had the FY start incorrect in the last file
edna v02.pbix (83.4 KB)