Divide monthly budget into daily

[dakins]

Hello Everyone,

I'd like to divide this montly budget to daily allocation. My budget table is below but by multiple products.

I tried the code below but to no avail:

Cal_Budget_Allocation =

VAR DaysInContext = COUNTROWS( 'Dates' )

VAR DaysInMonth = CALCULATE(COUNTROWS( 'Dates' ), All( 'Dates' ), VALUES( 'Dates' [MonthYear]))

VAR MonthlyBudgetAmounts =

    CALCULATE( [Total Budget], TREATAS( VALUES('Dates'[Month]), 'Budget'[MonthName]))

RETURN

IF(OR(HASONEVALUE( 'Dates'[Date]), HASONEVALUE( 'Dates'[MonthYear])),

DIVIDE( DaysInContext, DaysInMonth, 0) * MonthlyBudgetAmounts,

[Total Budget] )

My desired goal is use the date column from my date table to compare daily sales to budget allocation.

Thank you

[dakins]

@ryan_mayu Thanks for the reply.

Below is a google link to the sample budget file. My expected output is to have daily sales next to daily allocated budget.

https://docs.google.com/spreadsheets/d/1jrB28Iiy_QLGkEdbBPwNRbieOoIMnorn/edit?usp=sharing&ouid=11539... 

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[dakins]

Hello @Ashish_Mathur,

I am unable to download the PBI file. Can you send it again?

Thanks

[Ashish_Mathur]

File attached.

[ryan_mayu]

@dakins 

your screenshot is not clear

is this what you want?

Measure = sum('Table'[USBudgetAmount])/day(EOMONTH(max('Table'[Month]),0))

[dakins]

My desired output is this. Daily allocation of monthly budget

Thanks

[ryan_mayu]

@dakins 

you can try this

budget = maxx(FILTER('Table',year('Table'[Month])=year('date'[Date])&&month('Table'[Month])=month('date'[Date])),'Table'[USBudgetAmount])/day(eomonth('date'[Date],0))

pls see the attachment below

[ryan_mayu]

@dakins 

could you pls provide the sample data (not in the screenshot) and the expected output.