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
Measure - Month to Date Weekday Count
Re: Measure - Month to Date Weekday Count
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
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
Who is online
Users browsing this forum: No registered users and 3 guests