Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Max by ID from another table

I've tried a few solutipons to similar posts and can't find one that works. I have a table with multiple records per ID, some of which have a number in them (calculated field). My other table has one...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

To get the max value from table 1 to table 2 into a calculated column you can

MaxValueFromTable1 = 
VAR T2id = Table2[Id]
RETURN
MAXX(
  FILTER(
    Table1,
    Table1[Id] = T2id
  ),
  Table1[Number]
)
Johannes18's avatar
Johannes18
Regular Visitor
1 year ago

Hello, I think it should be rather like this:

MaxValueFromTable1 = 
VAR T2id = VALUES(Table2[Id])
RETURN
MAXX(
  FILTER(
    Table1,
    Table1[Id] IN T2id
  ),
  Table1[Number]
)