Forum Discussion
Helper VMAX 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 with MAX to no avail, it gives me the max date without taking into account the relationship, so all Unique IDs get the same date.
The sheets are connected with a one to many relationsship-
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.
7 Replies
- v-janeyg-msft
Community Support
Hi, bilingual
You can easliy create a measure or calculated column to display the result.
Like this:
Measure = MAXX(FILTER(ALL(Table1),[ID]=SELECTEDVALUE(Table2[ID])),[Date])Column = MAXX(FILTER(Table1,[ID]=EARLIER(Table2[ID])),[Date])If it doesn’t solve your problem, please feel free to ask me.
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.
bilingualThanks 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
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.
