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 referencne I have attached the image below.
1) Team 
2) Season 
3)Match 
4)player 

 

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())

2 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion
    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())