Count left working days in current month

[joslaz]

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.

=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

 

[macfuller]

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

 

[joslaz]

Thanks for your replay!

I have developed the following approach that works:

=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]

If it works, use it!