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 (DAX?) that would automatically return the "earliest" and "latest" date in a column of "Loss Dates", and paste that in each page so I dont have to update it.  Any recommendations on how I can do that?

 

Thanks in advance -   

Need Help
  • DataInsights's avatar
    DataInsights
    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:

     

     

2 Replies

  • DataInsights's avatar
    DataInsights
    Super User
    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: