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" )
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, lcap ;

If it is less than the end of the current month:

7 Reactive Report Before Current Month? =
IF ( [Case Reported On] <= EOMONTH ( TODAY (), 0 ), "Yes", "No" )

If it is less than the start of the current month:

7 Reactive Report Before Current Month? =
IF ( [Case Reported On] <= EOMONTH ( TODAY (), -1 ), "Yes", "No" )


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.