write dynamic header in DAX for Power BI report  

  RSS

TopicCreator
(@topiccreator)
Eminent Member Moderator
Joined: 12 months ago
Posts: 12
07/06/2018 11:41 am  

How we can write dynamic header in DAX for Power BI report


ReplyQuote
pankaj Gupta
(@pankaj-gupta)
Active Member Moderator
Joined: 1 year ago
Posts: 6
07/06/2018 11:43 am  

For multiple consecutive years selected, we could define a max year and a min year.

Header =
var minyear = MIN(dim_Date[Year])
var maxyear = MAX(dim_Date[Year])
var refreshdate = VALUES(fact_Premium[RefreshDate])
var datetype = VALUES('Date Type Slicer'[Date Type])
return "Report Period: " & minyear & " - " & maxyear & " As Of: " & refreshdate & " PST by " & datetype


ReplyQuote
Share:
  
Working

Please Login or Register