AnonymousNot applicable4 years agoSolvedCALCULATE 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...Show MoreIcey4 years agoHi 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.
Icey4 years agoHi 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.
Icey4 years agoHi 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_ctaulHelper I4 years agoYou can try something like this: Just adjusted it to be 1.07 instead of .07
AnonymousNot applicable to dvl_ctaul4 years agothis is not correct percentage we need to + again after * dvl_ctaulHelper I to Anonymous4 years agoYeah you're right, it should be 1.07 instead of .07. Everything else should work.
AnonymousNot applicable to dvl_ctaul4 years agothis is not correct percentage we need to + again after *
dvl_ctaulHelper I to Anonymous4 years agoYeah you're right, it should be 1.07 instead of .07. Everything else should work.
Related contentWorking with BudgetsCalculating Days late with specific target timesCalculate monthly budget to daily budgetDaily Sales Target CalculationBudget vs. Actual Calculation
