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] ) )
)
ajinkya1907's avatar
ajinkya1907
Helper II
8 years ago

Thanks for your quick response. Appreciate it !!

 

The solution which you provided gives attached error. Also we need to find out runner up as per last match in every year :-)

 

Data set is available at - https://www.kaggle.com/manasgarg/ipl/data

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago
Add it as a calculated column.
Not as a measure