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...
  • 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.

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.