Forum Discussion

ivancans's avatar
ivancans
Frequent Visitor
8 years ago
Solved

MAX date for an ID with repeating dates

Hello,   I would like to get your help in the following matter. I have ID's with multiple dates. I need to return latest date for each of the ID's and compare the result with the specific row. If t...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    ivancans

     

    Sorry I was out of office

     

    In Query Editor, you can use Group By Function to get the Max Dates for each ID

     

ivancans's avatar
ivancans
Frequent Visitor
8 years ago

Thanks Zubair_Muhammad but I thought that it is better to do it in query mode because it is somehow less hardware demanding procedure. Am I wrong on this one?

ivancans's avatar
ivancans
Frequent Visitor
8 years ago

Also, how can I filter out ture ones in data view so that the table becomes uniqe in relationship view. I did filter out the value but I still couldn't create relationship. See screens attached.  

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    ivancans

     

    Sorry I was out of office

     

    In Query Editor, you can use Group By Function to get the Max Dates for each ID

     

    • ivancans's avatar
      ivancans
      Frequent Visitor
      8 years ago

      Thank you Zubair_Muhammad ! I actually stumbled upon this solution half an hour ago, but nontheless this seems to be the right solution! :smileyhappy:

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Brilliant solution for this scenario!

      Thanks,

      Jeroen

    • cperazza's avatar
      cperazza
      Frequent Visitor
      3 years ago

      Hi Zubair_Muhammad 

      What if my dataset has more than 1 column apart from the ID (Group By), and I want to return the whole row? Is it possible?

      Thank you!