Help Max date

[Rally00]

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	14/03/2022
0WO1i000001yEKeGAM	15/03/2022
0WO1i000001yEKeGAM	16/03/2022
0WO1i000001yEKeGAM	17/03/2022
0WO1i000001yEKeGAM	13/03/2022
0WO1i000001yEKeGAF	16/03/2022
0WO1i000001yEKeGAF	17/03/2022
0WO1i000001yEKeGAF	13/03/2022

I expect a similar result

ID	Date
0WO1i000001yEKeGAM	17/03/2022
0WO1i000001yEKeGAF	17/03/2022

Thank you

Dom

[Anonymous · Accepted solution]

@Rally00 

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

[Anonymous]

hi @Rally00 ,

i think the is : 

Table 2 = SUMMARIZE('Table','Table'[ID],"DATE", LASTDATE('Table'[Date]));

i have tried this function with this example : 

ID                                                     Date

0WO1i000001yEKeGAM		12/03/2022
0WO1i000001yEKeGAM		14/03/2022
0WO1i000001yEKeGAM		15/03/2022
0WO1i000001yEKeGAM		16/03/2022
0WO1i000001yEKeGAM		17/03/2022
0WO1i000001yEKeGAM		13/03/2022
0WO1i000001yEKeGAF		16/03/2022
0WO1i000001yEKeGAF		18/03/2022
0WO1i000001yEKeGAF		13/03/2022

and the the result was : 

ID                                                DATE

0WO1i000001yEKeGAM		17/03/2022 00:00:00
0WO1i000001yEKeGAF		18/03/2022 00:00:00

hope that it can help 😄 

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

[Rally00]

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

.

[Anonymous · Accepted solution]

@Rally00 

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

[Rally00]

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 · Accepted solution]

Remove the extra closing square bracket .[Date]]

[Rally00]

Fantastic!!!!

Thanks

Dom

[mh2587]

Just select the earliest date option in the field section by clicking drop option you will see earliest date option

[Rally00]

Thanks for the answer but sorry I didn't understand. I forgot to mention that the result of the max will then join with another table via the ID

[mh2587]

Would you please upload the screenshot of the visulization pane of the right side