Summarising data in the same period

[Jawed]

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?

Thank you,

Sample.pbix (1.0 MB)

[Nick_M]

@Jawed
What if you add in the FY to your summarized table?

ADDCOLUMNS( 
	SUMMARIZE (
	    Actuals,
	    Actuals[GL Subaccount],
	    Actuals[Customer/Supplier],
	    Department[Department],
	    Actuals[Transaction Type],
	    Actuals[Cost Centre],
	    Actuals[Hard/Soft],
	    Actuals[Project],
	    Dates[FY]
    ),
	 "Date", CALCULATE( MIN ( Actuals[Date] )),
	 "Amount", [Total Actuals]
)

Nick

[Jawed]

Thank you, Nick. That did it perfectly.