Create a column with min of 5 variables.

[Anonymous]

Hi guys,

I need to built a column that the shows the min of datadiff beteween 5 columns, like:

Is the any way can show the min of thoso 5 variables?

Thanks

[ibarrau · Accepted solution]

Hi. Well this is a tricky one. You can use a lot of IF statements or you can build like a table with those and then use MIN. For example:

MINX(
    UNION(
        ROW("@VirtualColumn", a),
        ROW("@VirtualColumn", b),
        ROW("@VirtualColumn", c),
        ROW("@VirtualColumn", d),
        ROW("@VirtualColumn", e)
    ), [@VirtualColumn] 
)

That might be a way of avoid IF statement to get the minimun of the variables.

I hope that helps,