Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Max date for each year

Hello All, Need some help on the below issues. I have the below tables with me and want to find out the max date for each season(1 season is of 1 year) and rest all rows should be blank for the r...
General Comment
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    Try Create a calculated column 

    Max Val = 
Var Season = 'Table'[Season]
Var MaxDate = CALCULATE(MAX('Table'[Date]),FILTER('Table','Table'[Season]=Season))

RETURN 
IF('Table'[Season]=Season && 'Table'[Date]=MaxDate,MaxDate,BLANK())
ribisht17's avatar
ribisht17
Icon for Super User rankSuper User
4 years ago

Anonymous 

 

Please find the solution here IPL - Google Drive  

 

Regards,

Ritesh