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

 

IDDate
0WO1i000001yEKeGAM12/03/2022
0WO1i000001yEKeGAM14/03/2022
0WO1i000001yEKeGAM15/03/2022
0WO1i000001yEKeGAM16/03/2022
0WO1i000001yEKeGAM17/03/2022
0WO1i000001yEKeGAM13/03/2022
0WO1i000001yEKeGAF16/03/2022
0WO1i000001yEKeGAF17/03/2022
0WO1i000001yEKeGAF13/03/2022

I expect a similar result

IDDate
0WO1i000001yEKeGAM17/03/2022
0WO1i000001yEKeGAF

17/03/2022

Thank you

Dom

 

 

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

9 Replies

  • mh2587's avatar
    mh2587
    Super User
    4 years ago

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

    • Rally00's avatar
      Rally00
      Frequent Visitor
      4 years ago

      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's avatar
        mh2587
        Super User
        4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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