Daily Budget w/o Holidays and Weekends & Cumulative Budget Total Issue

[sscott]

Fellow Power BI Users -

First off, I cant thank you enough for the content you provide, has been well worth the small membership fee.

I can’t seem to figure this out and confuse myself more when trying to wrap my head around it.

1. I’m taking a budget and breaking it out to a daily budget excluding weekends and holidays
2. Using that measure to showcase the budget cumulatively.

When the date context is a selected month the totals line up fine, but when I remove the month filter and look at the whole year, the totals are not the same.

[EnterpriseDNA]

Thanks to the contributors of this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post, please make a new thread.