Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

CALCULATE TARGET BUDGET

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's avatar
    Icey
    4 years ago

    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.

4 Replies

  • dvl_ctaul's avatar
    dvl_ctaul
    Icon for Helper I rankHelper I
    4 years ago

    You can try something like this:

     

     

    Just adjusted it to be 1.07 instead of .07

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

       

      • dvl_ctaul's avatar
        dvl_ctaul
        Icon for Helper I rankHelper I
        4 years ago

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

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    4 years ago

    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.