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.