Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 fields, pace and date. I'm trying to return the pace value for the highest date for a KPI chart. I can get the date by max(Table.Date), but not sure how to refer to the pace value associated with it.
In SQL I know it would be something like select pace where date = max(date).
I'm sure it's something simple, but I'm just not getting it. Thanks in advance!
Try FirstSortedValue() function
FirstSortedValue([Pace Value], -[Table.Date])
Try FirstSortedValue() function
FirstSortedValue([Pace Value], -[Table.Date])
Perfect! Thank you Sunny!