Forum Discussion

bilingual's avatar
bilingual
Icon for Helper V rankHelper V
5 years ago
Solved

MAX DATE from One to Many relationsship

Hi i have some trouble making MAX DATE work.  I have a sheet with a unique ID and a sheet with multiple IDs , where i need to latest date to show up per each unique ID in the unique sheet. I tried ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, bilingual 

     

    You can simply modify the column.

    Like:

    Column = MAXX(FILTER(Table1,[ID]=EARLIER(Table2[ID])&&[Type]="Flex"),[Date])

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bilingual's avatar
bilingual
Icon for Helper V rankHelper V
5 years ago

Thanks Janey, it works perfectly, if i want to add an extra filter on it, could you be so kind to advise me for adding it to the Column ?

 

Column = MAXX(FILTER(Table1,[ID]=EARLIER(Table2[ID])),[Date])

 

Filter "Type" in Table1

 

Thanks

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, bilingual 

 

I have written both column and measure methods, you can use them according to your needs. And I don't have your sample data, so I don't know what you mean about 'Filter "Type" in Table1'. Can you explain it?

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • bilingual's avatar
    bilingual
    Icon for Helper V rankHelper V
    5 years ago

    Sorry for my bad explanation, i need one more condition for Max date, from Table1 there is a column named "Type" and only when Type="Flex" should maxdate be present

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi, bilingual 

       

      You can simply modify the column.

      Like:

      Column = MAXX(FILTER(Table1,[ID]=EARLIER(Table2[ID])&&[Type]="Flex"),[Date])

       

      Best Regards

      Janey Guo

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • bilingual's avatar
        bilingual
        Icon for Helper V rankHelper V
        5 years ago

        Thanks a lot, you helped me a lot!