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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , use these two with ID and name in a visual table

Value new lastnonblankvalue(Table[Datetimestamp], max(Table[Value]))
Datetimestamp new = lastnonblank(Table[Datetimestamp], blank())