How can I create custom column to bring in a value (lookup) from another table with conditions

[tinye]

Table 1

index

0

3

7

Table 2

0

1

2

3

4

5

6

7

What I want is to add a new column in table 2, I will use the first equal value in Table 1 for next rows until new value match.

here is my expectation:

Table 2

index    new column

0             0  (first matching in table 1)

1             0

2             0

3             3  (first matching in table 1)

4             3

5             3

6             3

7             7  (first matching in table 1)

[Fowmy · Accepted solution]

@tinye 

Add the following new column in Table two:

New Col = 
CALCULATE(
    MAX(Table1[Index]),
    Table1[Index] <= EARLIER(Table2[Value])
)