Forum Discussion

Dom87326's avatar
Dom87326
Helper II
5 years ago
Solved

Dynamic Title With Time Intelligence

Hello,    I have date table, date column 1:* fact table, date column. Two donut chart, left showing this year's data, other last years.    I try to add dynamic titles for two donuts, i.e. for cur...
  • Fowmy's avatar
    Fowmy
    5 years ago

    Dom87326 

    Last Year label: 

    LY Date = 

VAR __MIN =  CALCULATE( MIN(Dates[Date]) , SAMEPERIODLASTYEAR(Dates[Date]) )
VAR __MAX =  CALCULATE( MAX(Dates[Date]) , SAMEPERIODLASTYEAR(Dates[Date]) )
RETURN
    "Date range: " & FORMAT( __MIN , "MMMM/YY") & " TO " & FORMAT( __MAX , "MMMM/YY")
Fowmy's avatar
Fowmy
Super User
5 years ago

Dom87326 

Last Year label: 

LY Date = 

VAR __MIN =  CALCULATE( MIN(Dates[Date]) , SAMEPERIODLASTYEAR(Dates[Date]) )
VAR __MAX =  CALCULATE( MAX(Dates[Date]) , SAMEPERIODLASTYEAR(Dates[Date]) )
RETURN
    "Date range: " & FORMAT( __MIN , "MMMM/YY") & " TO " & FORMAT( __MAX , "MMMM/YY")