Forum Discussion
Solved
Calculating daily retail budgets
I am attempting to calculate budgets for retail stores for each day. The formula that I must use is Daily Budget = Sales/SUM(Sales); * Budget. The sum of the sales should be the sum of al...
igibson,
Create the following columns in your table.
Month = MONTH(Table[Date])Sumsales = CALCULATE(SUM(Table[Sales]),ALLEXCEPT(Table,Table[Month]))
Daily budget = Table[Sales]/Table[Sumsales]*Table[Bugdet]
Regards,
Lydiaigibson,
Just change the formula of Sumsales to the following:
Sumsales = CALCULATE(SUM(Table[Sales]),ALLEXCEPT(Table,Table[Month],Table[Store]))
Regards,
Lydia
