Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Temp table with Max Values

Hi I've a data that consists of entries similar tot he below Full Name TrainingSummary TrainingDate Elizabith Smith Not Started 1/1/2021 Smith Austin Partial 17/8/2021 Jacob Brown...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous You still need Lookup Min/Max:

    Table 2 =
  VAR __Table = 
    ADDCOLUMNS(
      SUMMARIZE('Table',[Full Name],"TrainingDate",MAX([TrainingDate])),
      "TrainingSummary",MAXX(FILTER('Table',[Full Name]=EARLIER([Full Name]) && [TrainingDate]=EARLIER([TrainingDate])),[TrainingSummary])
    )
RETURN
  __Table
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous You still need Lookup Min/Max:

Table 2 =
  VAR __Table = 
    ADDCOLUMNS(
      SUMMARIZE('Table',[Full Name],"TrainingDate",MAX([TrainingDate])),
      "TrainingSummary",MAXX(FILTER('Table',[Full Name]=EARLIER([Full Name]) && [TrainingDate]=EARLIER([TrainingDate])),[TrainingSummary])
    )
RETURN
  __Table
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Greg_Deckler works like a Charm 🙂