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.
IceyCommunity Support4 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.
Related contentWorking with BudgetsCalculating Days late with specific target timesCalculate monthly budget to daily budgetDaily Sales Target CalculationCreate a link between measure names and budgets/targets
