Forum Discussion
DAX MIN Function
Hello, I'm writing a DAX function and need to pass 4 arguments to the MIN function. However it appears in DAX the MIN function can only accept 2 arguments. Is there any workaround to overcoming the...
Hi Anonymous,
You can use Variables like in example below.Column = VAR m1 = MIN(YourTable[arguments1], YourTable[arguments2]) VAR m2 = MIN(YourTable[arguments3], YourTable[arguments4]) RETURN MIN(m1, m2)
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
You can use Variables like in example below.
Column = VAR m1 = MIN(YourTable[arguments1], YourTable[arguments2]) VAR m2 = MIN(YourTable[arguments3], YourTable[arguments4]) RETURN MIN(m1, m2)
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much - this solution works. I also discovered that it can be done by simply nesting the min functions in lieu of using VAR.