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" )
PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

for current month use

MONTH(TODAY()) && YEAR(TODAY())

 

So if have a date table, the expression would be

... 'Date Table'[Month] = MONTH(TODAY()) && 'Date Table'[Year] = YEAR(TODAY())

  • LYeo87's avatar
    LYeo87
    Helper II
    3 years ago

    Like this?

    7 Reactive Report Before Current Month? = IF([Case Reported On]<MONTH(TODAY()) && YEAR(TODAY(),"Yes","No")
    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      3 years ago

      See my previous post: I edited it to be more precise....

       

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

      You need to compare a month field with MONTH(TODAY()) and a year field with YEAR(TODAY()).

      What is your [Case reported on] measure returning?

      • LYeo87's avatar
        LYeo87
        Helper II
        3 years ago

        [Case reported on]  is a date field.