Hi,
Maybe you can try to use a complex CASE function.
Case | Returns value 1 if the condition is verified. Otherwise, returns value 2 | Case(When(<condition>, <value 1>), Else(<value 2>)) |
Ex: Case When Col1 < Col2 And Col1 < Col3 Then Col1
When Col2 < Col1 And Col2 < Col3 Then Col2
Else Col3