Forum Discussion
John02
4 years agoNew Member
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 (...
- 4 years ago
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:
John02
4 years agoNew Member
This was perfect! Thanks so much -