Amount of Working Days Left in Current Month

[jcwynes]

I'm working with PowerPivot and DAX and what I need is to write a Calculated Field that will return a single number that is the number of workdays left in the month.

I have a date table included with an IsWorkday calculated column which returns a 1 for a workday (Monday-Friday) and a 0 for a weekend (Saturday-Sunday).

What I'm having trouble finding is a formula that will give me the Last Date of the Current Month. If I have that then I can do something along the lines of summing up that IsWorkday column for the dates that are between Today and the Last Date of the Current Month

 

[rilzniak]

This will help you determine the number of work days left in the current month:

=NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0))

Also, with this formula you won't need the data table with the IsWorkday calculated.

The 'EOMONTH(TODAY(),0)' part determines the last date of the current month (in case you're wondering). Does that answer your question?

 

[jcwynes]

It does! Thank you!