Monthly Budget Allocations by Product Types

[dkalina97]

I have watched YouTube videos and checked topics here but I have been struggling with my budget allocation all week and this is the last item I need to finalize my model.

I have linked my Budget Table to my Sales by Type table. I am attempting to use the Budget Allocation measure below per a tutorial. But because that product type only had sales on 7 days, it is allocating it over 7 days and thus $9,253 per day, not over the number of days in June. Likewise, if I select March, rather than allocate over 31 days or $1,864 per day, it is using the number of days that had sales. How do I pull all dates in the month and allocate over all days even if there were no sales by that Sales Type on each day? Thank you!!!!!!

[dkalina97]

In addition, given that sales don't occur each day by each type, how do calculate the allocation to MTD as of today, given that the max date in the dates table in EOM, whereas the max sale date could be 3 days ago, but I would still want the budget to allocate through today.