Measure - Month to Date Weekday Count

Anything related to PowerPivot and DAX Formuale
BINoob
Posts: 5
Joined: Tue May 14, 2019 6:01 am

Measure - Month to Date Weekday Count

Postby BINoob » Thu Jun 06, 2019 12:40 am

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
Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

Re: Measure - Month to Date Weekday Count

Postby PhilC » Thu Jun 06, 2019 8:13 am

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


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests

cron