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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago
New Measure
MaxDate = IF(CALCULATE(MAX(Table1[Date]),ALLEXCEPT(Table1,Table1[UniqueId]))=MAX(Table1[Date])
,1,0)
I hope this might work for your requirement .