Hi,
I have Budget table, date table , sales table ,company table
Company table just got records UK and US and it is mapped with Budget table and Sales table.
I want to show Weekly budget. Can you please help me to calculate it. On page If i filter company, then it should show only filtered company buget per week. There will be Month and year filter.
Currently I am calculating
TotalBudgets=CALCULATE(SUM('Budget[mONTHLYbUDGET]),TREATAS(VALUES(Dates[MonthYear]),'Budget'[MonthYear]))
I am calculating BudgetPerDay =
var BudgetperMonth =CALCULATE([TOTAL BUDGET],FILTER(Dates,Month(dates[Date])=Month(Max(Dates[Date]))),FILTERS(Company[Company]))
RETURN
9ISFILTERED(Dates[Date]),
DIVIDE(BudgetPerDay,[WorkingDaysinMonth],0),[TotalBudget])
Budget table structure and value example.
| Company | Product | MonthYear | Monthly Budget | PerDay Budget | Working days | Date |
| UK | A1 | 01 2021 | 5000 | 227.27 | 22 | 01/01/2021 |
| US | A1 | 01 2021 | 7000 | 318.18 | 22 | 01/01/2021 |
| UK | A2 | 01 2021 | 4000 | 181.81 | 22 | 01/01/2021 |
| UK | A3 | 02 2021 | 7000 | 318.18 | 20 | 01/02/2021 |
| US | A3 | 02 2021 | 7000 | 318.18 | 20 | 01/02/2021 |
| UK | A4 | 02 2021 | 8000 | 400 | 20 | 01/02/2021 |
