Get Minimun value from related table after first iteration

[chilitomex]

Need help trying to solve this problem.... im bringin data to a table A from another related table B.

Eg:

Table B
31/04/2024 Blue

22/03/2024 Blue
05/02/2024 Red

03/02/2024 Blue

I need to get the MIN date for BLUE (before iterating to Red) in this case should get 22/03/2024.

Any idea??

[samratpbi · Accepted solution]

Hi, You can create a relationship between the 2 tables based on your color column.
For demo, I created 2 sample tables:

then create a join between these 2 using color column.

then create the below measure:

Min Date RB = MIN(RedBlueTabB[Date])

this gives be the desired result:

Hope this helps to resolve your problem. If it does, then please mark it as solution, thanks!