Calculate % of the Goal

[Syndicate_Admin]

Hello, someone can help me as I make a calculation that I have tried in a thousand ways and does not give me.

I need from a column Budget Goal (ahem 1,000,000)

Knowing at what time (date) of that value reaches 40%, then I have many days and several months with day by day sale (ahem January 1 to December 31). Then know according to those values at what time (date) is 40% of it. If the value gives 400,000 on May 30, then bring me that date of May 30.

I appreciate very much if anyone knows. Thank you

[Syndicate_Admin]

Hello, thank you very much for your help but I tell you that I did it to the letter as you pass it to me and it does not give me

Look what he is giving me, he gives me the first date of all the data as such

and when doing the calculations on the outside it gives me that on 09/17/2023 I should comply with 40%

I made the same formula and it gives me the first date of the data as such.

and the sum calculation is as follows

How could it be identified on what date it will meet that 40%

Thank you very much

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26Rh2F320IXcppMayJt?e=hfUFgf

[Ashish_Mathur]

Hi,

Share some data and show the expected result.