Forum Discussion

JemmaD's avatar
JemmaD
Icon for Helper V rankHelper V
3 years ago
Solved

Combine text with max date for dynamic title

I have done this before, but i've clearly forgotten how to build a simple measure because my syntax is not working.  I want to create a measure which says "Online Monthly Service for month year" whe...
Need Help
  • JorgePinho's avatar
    JorgePinho
    3 years ago

    Hello JemmaD ! 
    Try: 

    Report Title = CONCATENATE("Online Monthly Service for ",FORMAT ( MAX ( 'DimDate'[Date] ), "MMM YYYY" ))
JorgePinho's avatar
JorgePinho
Icon for Solution Sage rankSolution Sage
3 years ago

Hello JemmaD ! 
Try: 

Report Title = CONCATENATE("Online Monthly Service for ",FORMAT ( MAX ( 'DimDate'[Date] ), "MMM YYYY" ))