topic Re: Dax Formula to Calculate Remaining Allocated Funds, from todays date to end of the financial year in DAX Commands and Tips

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

Anonymous — Tue, 19 Jul 2022 13:07:02 GMT

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

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

daXtreme — Tue, 19 Jul 2022 13:56:09 GMT

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

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

Anonymous — Mon, 25 Jul 2022 10:21:57 GMT

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