Forum Discussion

WJ876400's avatar
WJ876400
Icon for Helper IV rankHelper IV
3 years ago
Solved

show one row

Hi,   I have a set of data that has multiple dates for one ID like below -     what I want to show is just the lastest date for each ID, is this possible to do so I can show it in a table ...
Need Help
  • vk_pbi's avatar
    vk_pbi
    3 years ago

    Hi WJ876400 

    You can use MAXX function to iterate each record for a ID, get the MAX date.. 

vk_pbi's avatar
vk_pbi
Icon for Resolver II rankResolver II
3 years ago

Hi WJ876400 

You can use MAXX function to iterate each record for a ID, get the MAX date..