CALCULATE TARGET BUDGET

[Anonymous]

I HAVE A FIVE YEAR DATE TABLE 2020-2025 AND SALES TABLE  (PAYMENT) IS ACTUAL SALES BASED ON CATEGORIES,SUBCATEGORIES AND STORENO PAYMENT ONLY HAVE 2020 AND 2021 SALES  NEED TO CALCULATE TARGET BUDGET WHICH IS +7% OF OF PREVIOUS YEAR (2020) PAYMENT BUT IN FUTURE WHEN WE ENTER 2022 SALES IT REPEATS +7% TO THAT PREVIOUS YEAR(2021)  PAYMENT AND SO ON . THANKS

[Icey · Accepted solution]

Hi @Anonymous ,

You can try to use POWER function like so:

Sales = POWER(1.07,MAX('Table'[Year])-2020) * 100(the value of 2020)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dvl_ctaul]

You can try something like this:

Just adjusted it to be 1.07 instead of .07

[Anonymous]

this is not correct percentage we need to + again after *

[dvl_ctaul]

Yeah you're right, it should be 1.07 instead of .07. Everything else should work.