Forum Discussion
Solved
2nd to most recent date
Hi all, I have two tables in my dataset: HSCompanies: Contains 1 row for each company HSHealthScores: Contains multiple rows of health scores for each company I'm trying to retrieve the ...
You are welcome. Revise the measure to
PenultimateScore = CALCULATE(MAX(HSHealthScores[Score]),DATESBETWEEN('Calendar'[Date],[PenultimateScoreDate],[PenultimateScoreDate]))
Is that the whole formula? I get this message:
A table of multiple values was supplied where a single value was expected.
- lbendlin
Super User
SecondMostRecentCRFDate = MAXX(OFFSET(-1,ALLSELECTED('HSHealthScores'[StartDate])),[StartDate])
