Spreading Budgeted Cost Across Months

[juliecornelius]

I have a project which is resource loaded with manpower and fixed costs and I'm working on a report to project when we will spend the dollars. I searched this forum and found instructions to do this by creating a calendar table and crossjoining my original table and the calendar table.  (https://community.powerbi.com/t5/Desktop/Splitting-Values-between-months-of-two-dates/m-p/181278#M79...)

However, I'm not getting the correct results.  The matrix looks the way I want it to, but it is missing any values which don't begin on or span the first day of the month.  How can I make it display values which fall at any point in the month, not just on the first day of the month?  I would appreciate any help anyone can give me.  Thank you!

[Stachu · Accepted solution]

You are missing ', 0' as second argument in EOMONTH, and you should remove MONTH in the EOMONTH as here

<=EOMONTH(Tasks[TaskFinishDate], 0)

[Anonymous]

ENDOFMONTH is a time-intelligence function and will only work correctly on a proper Date table. You cannot use it on a column in any other table. If you do, either you'll get an error or the returned value will be unreliable.

Best

Darek