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.

camargos88's avatar
camargos88
Community Champion
5 years ago

Anonymous ,

 

Perhaps a card with measure returning que current year works.

Can you provide more details ?

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 below in the header of report whether there is data or not

 

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