Dax Formula to Calculate Remaining Allocated Funds, from todays date to end of the financial year

[Anonymous]

Hi All I am looking for a Dax Formula to Calculate Remaining Allocated Funds, from todays date to end of the financial year(July-June), this needs to be dynamic and adjust as time goes by. For financial years that hat have passed, just needs to capture remaining allocated funds for that financial year(maybe an if statement in this case). Please help

Table examples

Project Funding Allocation 

Allocation ID	ProjectID	Date	Status	Allocation
3	1001	01/07/2022	Project-Approved	5,000,000
4	1002	01/08/2022	Project-Offset	3,500,000
5	1001	01/09/2022	Project-Approved	1000,000

Project Actuals 

Actual ID	Project ID	Date	Status	Allocation
2	1001	01/07/2022	Project-Approved	5,000,000
3	1003	01/08/2022	Project-Offset	3,500,000
4	1001	01/092022	Project-Approved	1,000,000

[Anonymous]

Hi @Anonymous ，

What do you want the results to look like? Could you please give the final result you want based on the data you provided? Also explain the logic of the calculation. Thank you.

Best Regards

[daXtreme]

How to Get Your Question Answered Quickly (powerbi.com)