Count left working days in current month

joslaz

Board Regular
Joined
May 24, 2018
Messages
70
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:
DateB_MonthWorkday
01.01.2019Jan0
02.01.2019Dec1

<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
 

macfuller

Board Regular
Joined
Apr 30, 2014
Messages
242
Your CALCULATE doesn't have an operator like SUM(). Assuming all your other logic and relationships are good...
 

joslaz

Board Regular
Joined
May 24, 2018
Messages
70
Thanks for your replay!

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?
 

Forum statistics

Threads
1,077,772
Messages
5,336,150
Members
399,067
Latest member
CJWFM

Some videos you may like

This Week's Hot Topics

Top