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
Icon for Community Champion rankCommunity 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 🙂