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
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Greg_Deckler  for your reply. Maybe I used the wrong word. I don't want to create temp table but calculated table that contains information the way I described so that I can report against it.

     

    I went to the link you shared but I thought maybe when I mentioned temp table I confuses the question 

    • 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 🙂