topic Re: Sum of Working Days till end of this month in DAX Commands and Tips

Sum of Working Days till end of this month

y5famfnatudu — Fri, 14 Feb 2025 10:42:59 GMT

Dear All,

Some how I can't get the sum of working days till the end of the current month, because I have a filter in the report that is called "isPastDay", how can I overcome this issue?

The measures are as follows:

Working Days = CALCULATE ( COUNTROWS ( FILTER ( 'Date', 'Date'[Date] <= TODAY () ) ), 'Date'[isWD] = "1" )

Working Days ToBe = CALCULATE ( COUNTROWS ( 'Date' ), 'Date'[isWD] = "1", REMOVEFILTERS ( 'Date'[isPast] ) )

What I'm expecting to see, is 41 instead of 250

Your help is so much appreciated.

Best regards,

Simon

Re: Sum of Working Days till end of this month

bhanu_gautam — Fri, 14 Feb 2025 10:58:10 GMT

y5famfnatudu Try using

DAX
Working Days =
CALCULATE (
COUNTROWS ( FILTER ( 'Date', 'Date'[Date] <= TODAY () ) ),
'Date'[isWD] = "1"
)

Working Days ToBe =
CALCULATE (
COUNTROWS ( FILTER ( 'Date', 'Date'[Date] > TODAY() && 'Date'[Date] <= EOMONTH(TODAY(), 0) ) ),
'Date'[isWD] = "1",
REMOVEFILTERS ( 'Date'[isPastDay] )
)

Re: Sum of Working Days till end of this month

y5famfnatudu — Fri, 14 Feb 2025 11:44:24 GMT

Thank you bhanu_gautam
The measure Working Days ToBe is showing 10 by Feb, but blank by the rest

Re: Sum of Working Days till end of this month

y5famfnatudu — Fri, 14 Feb 2025 14:38:49 GMT

I got the measure to work

Working Days ToBe = VAR _EndOfCurrentMonth = EOMONTH ( TODAY (), 0 ) VAR _WDtillEndOfCurrentMonth = CALCULATE ( COUNTROWS ( FILTER ( 'Date', Date[Date] <= _EndOfCurrentMonth ) ), Date[isWD] = "1", REMOVEFILTERS ( Date[isPast] ) ) RETURN _WDtillEndOfCurrentMonth