Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Text for month in text box

Hello everyone, 

 

This may be a simple question, I appreciate all the help. I am trying to make a monthly dashboard, and have a text box that changes dynamically depending on the current month. So this month it would be 'November 2020 Overview", and next month "December 2020 Overview". 

 

Would anyone know how to do this? 

 

Thank you for the help, 

 

Denisse

3 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi, Anonymous , you might want to use such a measure as dynamic title of the report,

    Title = FORMAT(TODAY(), "mmmm yyyy") & " Overview"
  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous 

    Create a measure

    TestM =
MAX ( DateT[Month] ) & " " & MAX ( DateT[Year] ) & " Overview"

    and place it in a card visual.

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try like

     

    this month = format(today(),"MMMM YYYY ") & "Overview"

    next month = format(eomonth(today(),1),"MMMM YYYY ") & "Overview"