Forum Discussion

ssvr's avatar
ssvr
Helper III
8 years ago
Solved

DAX

I want to create a measure; Fetch the Month name from Date column
  • danextian's avatar
    8 years ago
    You can try this
    MonthName=
    VAR Date_= SELECTEDVALUE(Table[DateColumn])
    RETURN FORMAT(Date_, "mmmm")

    Note: this returns a value if there is only one date in the current filter context.

    If this isn't what your desired result, please provide a sample date and your expected result.