Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |