Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Was wondering if anyone have the DAX calculations to count how many days left in a current month?
Solved! Go to Solution.
Workdays Left in Month = COUNTROWS( FILTER( CALENDAR( TODAY(), EOMONTH(TODAY(), 0) ), WEEKDAY([Date], 2) < 6 ) )
...assuming that by "working" days you mean Monday through Friday.
The formula I gave previously does not count today as one of the days left in the month. This one does. If you don't want it to count today, you just have to move the start date to tomorrow:
Workdays Left in Month = COUNTROWS( FILTER( CALENDAR( TODAY() + 1, EOMONTH(TODAY(), 0) ), WEEKDAY([Date], 2) < 6 ) )
Proud to be a Super User!
Days Left in Month = INT(EOMONTH(TODAY(), 0) - TODAY())
Proud to be a Super User!
Thanks! Now let me expand on this, how would I calculate "Working" days?
Workdays Left in Month = COUNTROWS( FILTER( CALENDAR( TODAY(), EOMONTH(TODAY(), 0) ), WEEKDAY([Date], 2) < 6 ) )
...assuming that by "working" days you mean Monday through Friday.
The formula I gave previously does not count today as one of the days left in the month. This one does. If you don't want it to count today, you just have to move the start date to tomorrow:
Workdays Left in Month = COUNTROWS( FILTER( CALENDAR( TODAY() + 1, EOMONTH(TODAY(), 0) ), WEEKDAY([Date], 2) < 6 ) )
Proud to be a Super User!
@KHorsemanI'm trying to change it to calculate how many workdays passed on current month, any hint?
Awesome! Thank you!
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |