Forum Discussion

adkayak86's avatar
adkayak86
Frequent Visitor
1 year ago
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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    You are welcome.  Revise the measure to

    PenultimateScore = CALCULATE(MAX(HSHealthScores[Score]),DATESBETWEEN('Calendar'[Date],[PenultimateScoreDate],[PenultimateScoreDate]))

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi adkayak86  ,

 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.