I am trying to create a projection based on an average multiplied by the number of business days in the month as well as account for holidays.
I have a rolling dynamic calendar that adds a new date automatically every day and have a calculation already to count the business days. My challenge is that it only counts bussiness days based of the rolling calendar and therefore does not give me an accurate count for the whole month.
This has lead me to create a separate static date table. The problem is I have not been able to relate the two calendars together. I have a column in my static date table that tells if its the current month but its very limited as it will not work with a date slicer.
Any thoughts on how I might do this all from my dynamic calendar? Or if that’s not possible have the static calendar count business days based of the date selection.
I know this was a little complicated so I attached a sample file. Any help would appreciated. I have been scratching[Counting Business Days my head a little on this one.
Counting Business Days.pbix (72.1 KB)