Count left working days in current month

joslaz

Board Regular
Joined
May 24, 2018
Messages
72
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
 

Some videos you may like

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
Joined
Apr 30, 2014
Messages
257
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
72
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,090,078
Messages
5,412,229
Members
403,423
Latest member
fori_gump

This Week's Hot Topics

Top