Dynamic Text for month in text box

[Anonymous]

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

[amitchandak]

@Anonymous , Try like

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

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

[CNENFRNL]

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

Title = FORMAT(TODAY(), "mmmm yyyy") & " Overview"

[AlB]

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