Calculated column based on two related columns

[joshua1990]

Hey guys!

I need to determine the max value for a specific case.

I have a simple sales table that contains some basic information per order with these columns:

• Order-Nr (Key column)
• Step Name
• Value

This table contains 1 row per order

Then I have a second table that is linked to this table using the Order-Nr and contains some more information:

• Order-Nr
• Step Name
• Status

This table shows me the routing per order and contains several rows per order.

Now I would like to add a calculated column into the first table that contains the Max Status for each order and the corresponding step name. The first table already has the latest Step name per Order. I just need to add the latest Status for the order and the latest Step Name

[amitchandak]

@joshua1990 , Try a new column in Table 1

maxx(filter(Table2, Table2[Order-Nr] = Table1[Order-Nr] && Table2[Step Name] = Table1[Step Name] ),Table2[Status])