Forum Discussion

ajinkya1907's avatar
ajinkya1907
Helper II
8 years ago
Solved

Problem in selecting Max date

  I have a table "matches" with below shown columns     I have created calculated field Max_date = MAX(matches[date])   I have created a filter based on year. I want team1 value to be di...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    ajinkya1907

     

    Try this MEASURE to get the TEAM1 on maximum date

     

    Team1 On MaxDate =
CALCULATE (
    FIRSTNONBLANK ( Matches[Team1], 1 ),
    FILTER ( ALL ( Matches[Date] ), Matches[Date] = MAX ( Matches[Date] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago
Add it as a calculated column.
Not as a measure
ajinkya1907's avatar
ajinkya1907
Helper II
8 years ago

Thanks Zubair for your quick response.

 

I was looking for to achieve it with calculated measure. As no solution I can think about, I created new column as below

IPL_RunnerUp2 = IF(matches[team2]<>matches[winner],matches[team2],matches[team1])

 

and on that I applied max date logic as per your earlier suggestion for winner team. It worked fine for Runner up team. Thanks for your help.