Forum Discussion
Solved
Add a Colum with a value based on a conditional test between value of 2 different Table
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 ...
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])
amitchandak Thank you so much !