I have created a table from actual data using Summarize. Our Financial Year (FY) is April - March. The data straddles between two FYs (FY19 and FY20). The problem is that now my Summarised Table for FY19 is pulling more data which would normally be related to FY20. As such, there is now over £19K difference between two years where (see screenshot below). I have used Min for the dates in the summary Table (see the Table formula below).
The question is, how would I go about to ensure that the data is pulled in the right FY as the grand total for both years do match?
Sample.pbix (1.0 MB)