Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    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.

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

I'm not sure if you mean you want to show the current year i.e. 2020, or the currently selected year?

And do you want the heading to read Sales for the year 2020 ?

Please clarify.  If you just want the current year (2020) this measure will do

 

Current Year = CONCATENATE("Sales for the Year ", FORMAT(TODAY(),"yyyy"))

 

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    so here is the requirement, It doesnt have to do anything with the data, 

    In my power bi heading for the report, I just want to show 

     

    sales report - November 2020 

     

    The month and year should always show current month and year....thats all, nothing fancy, I can write oracle function to display this information in the oracle view i am using as source, but if there is no data for the month it would be empty....can I use dax somehow in the power bi header to show this info ? (maybe in a card ?) , dont want to invovle data table etc