Measure - Month to Date Weekday Count

[BINoob]

I have various Measures created. There are a couple of them that I would like to divide by the number of Weekdays (workdays) that have passed Month to Date so that I can get the average per workday. How would I be able to work that in to an existing Measure? Do I have to work that in to the Measure that does the calculation?

Thanks,

John

[PhilC]

Hi John,

My suggestion is if you need to calculate a result by the number of workdays, you should create additional measures, rather than working into an existing measure. That is one of the great things about DAX, to build on previous measures to reduce the complexity of any one measure.

The DIVIDE function is fairly simple, DIVIDE([Numerator measure],[Denominator measure]), so you just need a measure to calculate the number of working days to be your denominator measure.

Maybe the following will help.

Approach to add a counter to a Date table
https://www.sqlbi.com/articles/counting ... ys-in-dax/

I have not watched this but EnterpriseDNA has great approaches to things
https://www.youtube.com/watch?v=y0DdFfeuwR4

Cheers
Phil