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