Get max value of a group in a related table

[PhiBu]

Hello, 

i have two related tables with an 1:n relation.

Table 1: 

Key	Created
A	04.20.2020
B	04.25.2020

Table 2: 

Key	Updated
A	04.22.2020
A	04.25.2020
A	04.29.2020
B	04.26.2020
B	04.27.2020
B	04.28.2020

I want to add a column in Table1 with the max. date of Table2 for every key.  How can i do that? I tried something with groupby and max, but it was not working. 

Best regards!

[v-lili6-msft]

hi  @PhiBu 

You could create a column by this formula:

Column = MAXX(RELATEDTABLE('Table 2'),'Table 2'[Updated])

Regards,

Lin

[amitchandak]

@PhiBu , new column in table 1

Updated = sumx(filter(Table2, table1[key]=Table2[key]),Table2[Updated])

[AlB · Accepted solution]

Hi @PhiBu 

Making use of the relationship:

NewColumn = CALCULATE( MAX(Table2[Updated]) )

 Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers