Weekly Budget Allocation

[mb0307]

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

[amitchandak · Accepted solution]

@mb0307 , PLease find the file where I have split monthly budget into daily, from there you can build weekly

One is measure way, another one is table way