Forum Discussion
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...
And if you want to use DAX
Table2 = SUMMERIZE( Table1, Table1[Id], "Max Number",CALCULATE(Max(Table1[Number])) )
Kristjan, I simplified my data and possibly left out some key pieces. My Table2 is an already existing table with other columns that I left out of my example. My Number column in Table1 is a calculated measure, so it won't pull into a new summarized table.
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] )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] )
