Forum Discussion

tropic's avatar
tropic
Frequent Visitor
3 years ago
Solved

Dynamic Date Measure

Hi. I need to create a card that would show me the month and year selected in the date slicer. This is what I have for now as my measure: YTD Test = Var mm = FORMAT(SELECTEDVALUE('DATE'[Month Num...
  • ryan_mayu's avatar
    3 years ago

    tropic 

    pls try this

     

    YTD Test =
    Var mm = FORMAT(max('date'[Date]),"mmmm")
    Var yy = SELECTEDVALUE('DATE'[Year])


    RETURN
    mm&" "&yy