Forum Discussion
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...
Remove the extra closing square bracket .[Date]]
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 😁
Thank you very much for the answer but where do I insert the function? 😁
.
- Hi I have inserted the following function, as you indicatedT_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?ThanksDom
Remove the extra closing square bracket .[Date]]