Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@Anonymous , Try like
this month = format(today(),"MMMM YYYY ") & "Overview"
next month = format(eomonth(today(),1),"MMMM YYYY ") & "Overview"
Hi, @Anonymous , you might want to use such a measure as dynamic title of the report,
Title = FORMAT(TODAY(), "mmmm yyyy") & " Overview"
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |