Forum Discussion
Show current year
I am preparing a header for my power bi report in the following way Sales for the year 2020 - question is how do I show the year dynamically ? Can I add a new column to the report in the power bi...
Hi Anonymous ,
Try this:
Measure = "My header -" & FORMAT ( TODAY (), "mmmyyyy" )Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
I am using card visual and a measure in the table, so good thing is, even though there is no data in the report I can see the header
Measure = "My header -"& format(month(today()),"mmm") & year(today())
why is it showing Jan2020 ? why not current month ?
Hi Anonymous ,
Try this:
Measure =
"My header -" & FORMAT ( TODAY (), "mmmyyyy" )
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.