Add a Colum with a value based on a conditional test between value of 2 different Table

[sdlx]

Hello,

I have 2 table.

First Table

Batch

Start Value Batch (Decimal Number)

End Value Batch (Decimal Number)

Second Table

Start Value Reason (Decimal Number)

My Goal is to add the Batch Value From the first Table to the second table.

The batch Value to retrieve is the one where the Start Value Reason is between Start Value Batch and End Value Batch.

multiple rows of the Second Table will Get the same Batch Value of the First Batch.

Thank you all for your help !

[sdlx]

@amitchandak Thank you so much !

[amitchandak · Accepted solution]

@sdlx , Try a column like

maxx(filter(table1, Table2[Start Value Reason] >= Table1[Start Value Batch]  && Table2[Start Value Reason] <= Table1[End Value Batch] ), Tabl1[Batch])