Forum Discussion

John02's avatar
John02
New Member
4 years ago
Solved

return date range from a column

I have a text box at the top of several pages.  I've been manually updating the "Loss Date" range that I display in that table from my data table when I refresh the data.  I'd like to add a formula (...
  • DataInsights's avatar
    4 years ago

    John02,

     

    Try this measure:

     

    Loss Date Label = 
    "Earliest Loss Date: " & MIN ( Table1[Loss Date] ) & "; " & "Latest Loss Date: "
        & MAX ( Table1[Loss Date] )

     

    In the Title properties of the text box, click the "fx" icon and select the measure:

     

     

    Result: