Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Latest datetimestamp by id

Hi,   I have 4 columns ID Name         Datetimestamp                Value 1   BMI     2020/08/04 12:23:12               12 1   BMI     2020/08/11 08:22:10               15 2   BMI     2020/08/1...
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Anonymous 

    you can also create a new table

    Table 2 = ADDCOLUMNS(SUMMARIZE('Table','Table'[ID],'Table'[Name ],"datetimestamp",MAX('Table'[Datetimestamp ])),"value",MAXX(FILTER('Table','Table'[Datetimestamp ]=[datetimestamp]),'Table'[Value]))

FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

take a look at the following solution:

 

 

Last DateTimeStamp = LASTNONBLANKVALUE('Table'[Datetimestamp],MAX('Table'[Datetimestamp]))

Value that belongs to Last = LASTNONBLANKVALUE('Table'[Datetimestamp],MAX('Table'[Value]))

 

Regards FrankAT