Forum Discussion

lcap's avatar
lcap
New Member
3 years ago
Solved

DAX 'Current Month'

Hiya,   I'm struggling to work out how to formulate a column with an IF statement - i'm stuck how to express Current Month.   Thanks in advance.  
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    Try:

    Before current month =
VAR _YMToday =
    YEAR ( TODAY () ) * 100
        + MONTH ( TODAY () )
VAR _YMField =
    YEAR ( MAX ( 'Dates Table'[Date] ) ) * 100
        + MONTH ( MAX ( 'Dates Table'[Date] ) )
RETURN
    IF ( _YMField = _YMToday, "Current month" )
LYeo87's avatar
LYeo87
Helper II
3 years ago

[Case reported on]  is a date field.

PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Actually the code I posted will not return previous dates in previous years which are > MONTH (TODAY()).

So you can either use:

Before current month = 
VAR _YMToday = YEAR(TODAY()) * 100 + MONTH(TODAY())
VAR _YMField = YEAR(MAX('Dates Table'[Date])) * 100 + MONTH(MAX('Dates Table'[Date]))
RETURN
IF(_YMField < _YMToday, "Previous")

 

or

Alternative =
IF (
    MAX ( 'Dates Table'[Date] )
        < STARTOFMONTH (
            FILTER ( ALL ( 'Dates Table'[Date] ), 'Dates Table'[Date] = TODAY () )
        ),
    "Alternative"
)