Number of WD left in any period...month

[Anonymous]

Hi Expert

I have the following DAX measure - which shoul dgive me the number of days left in any given month if the period is iin the past then zero. if current month and future day then work out how many days left in those period... but cannot see error

Workdays Left in Month = IF(INT(EOMONTH(TODAY(),0) - TODAY())<TODAY(),BLANK(),INT(EOMONTH(TODAY(),0) - TODAY()))

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

If you have a model like it in the attachment. You can try this formula.

Measure =
IF (
    EOMONTH ( MIN ( 'Calendar'[Date] ), 0 ) <= EOMONTH ( TODAY (), -1 ),
    9999,
    IF (
        TODAY () IN VALUES ( 'Calendar'[Date] ),
        DATEDIFF ( TODAY (), EOMONTH ( TODAY (), 0 ), DAY ),
        DAY ( EOMONTH ( MIN ( 'Calendar'[Date] ), 0 ) )
    )
)

Best Regards,
Dale

[Anonymous]

Thanks Dale let me test. Measure.