Forum Discussion
Self Updating Working Days Measure
I want to create a new measure that automatically updates the number of completed days that have occured for that particular month. For example, these are what I want the outputs of that measure to equal:
06/01/23 = 1
06/02/23 = 2
06/05/23 = 3
06/12/23 = 8
etc...
I would like to be able to reset this, automatically or manually, each month.
Thank you for you help
1 Reply
Hi Anonymous it seems you need Date table in Power BI for working / Business days.
Examples: https://medium.com/microsoft-power-bi/using-networkdays-function-in-dax-to-calculate-business-
https://www.madeiradata.com/post/calculate-working-days-in-dax
Hope this help
