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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]B_Month[/TD]
[TD]Workday[/TD]
[/TR]
[TR]
[TD]01.01.2019[/TD]
[TD]Jan[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]02.01.2019[/TD]
[TD]Dec[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


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!