# Count left working days in current month

#### joslaz

##### Board Regular
Good day everybody,

I am facing a relatively trivial problem, but somehow I can not continue.

Aussprache lernen
I would like to know how (dax measure) many working days are still available in the current business month from today (in Excel/ Power Pivot).

I have the following table:
 Date B_Month Workday 01.01.2019 Jan 0 02.01.2019 Dec 1

<tbody>
</tbody>

As you can see, the business month is different from the normal month.

Code:
``````=VAR CurrentDay = MAX('Calendar'[Date])
VAR CurrentMonth = MAX('Calendar'[B_Month])
RETURN
CALCULATE('Calendar'[Workday];
FILTER(ALL('Calendar'[Date]); 'Calendar'[Date] <= CurrentDay &&
'Calendar'[B_Month] = CurrentMonth))``````

I constantly receive only any error messages.

Does somebody has any idea?

Best Regards

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### macfuller

##### Active Member
Your CALCULATE doesn't have an operator like SUM(). Assuming all your other logic and relationships are good...

#### joslaz

##### Board Regular

I have developed the following approach that works:
Code:
``````=VAR LastDayOfCurrentMonth = MAX('Calendar'[Date])Return
CALCULATE(
COUNTROWS('Calendar');
FILTER('Calendar';'Calendar'[Date] >= TODAY() && 'Calendar'[Date] <= LastDayOfCurrentMonth);
FILTER('Calendar'; 'Calendar'[Workday]>= 0,5))``````
What do you think?
Are there any potential issues?

#### macfuller

##### Active Member
If it works, use it!