Forum Discussion

Rally00's avatar
Rally00
Frequent Visitor
4 years ago
Solved

Help Max date

Hello everyone, for a table I should group the values ​​by max date. In particular, for each ID I should have the maximum date   ID Date 0WO1i000001yEKeGAM 12/03/2022 0WO1i000001yEKeGAM...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Rally00 

     

     

    Did I answer your question? Thanks to mark my post as a solution 

     

  • mh2587's avatar
    mh2587
    4 years ago

    Remove the extra closing square bracket .[Date]]

Rally00's avatar
Rally00
Frequent Visitor
4 years ago

Thank you very much for the answer but where do I insert the function? 😁

.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Rally00 

 

 

Did I answer your question? Thanks to mark my post as a solution 

 

  • Rally00's avatar
    Rally00
    Frequent Visitor
    4 years ago
    Hi I have inserted the following function, as you indicated 
    T_Max_Receipdate = SUMMARIZE(gii__receipt__c,gii__receipt__c[gii__transferorder__c],"DATE",LASTDATE(gii__receipt__c[gii__receiptdate__c - Date].[Date]]))
    but now the message "the end of the input has been reached" appears .. what is not correct?
    Thanks
    Dom
     
    • mh2587's avatar
      mh2587
      Super User
      4 years ago

      Remove the extra closing square bracket .[Date]]

      • Rally00's avatar
        Rally00
        Frequent Visitor
        4 years ago

        Fantastic!!!!

        Thanks

        Dom