Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago
Solved

MIN with Multiple Columns

Hi, I have problems getting the min value of dates returned across more than two columns.   For instance columns C1, C2, C3, C4 and C5.   How can I get a column or a measure returning the min va...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • DoubleJ's avatar
    DoubleJ
    8 years ago

    Hi Kristoffer

     

    You could create a new column with DAX and use the MIN() function. As MIN() only takes 2 arguments you have to nest them:

     

    MinValue = MIN(MIN(MIN(MIN(Demo[C1],Demo[C2]),Demo[C3]),Demo[C4]),Demo[C5])

    There might be an easier way which I am not aware of.

     

    Hope this helps!

    JJ

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Kristofferaabo

     

    You can use this calculated column

     

    Column =
VAR temp = { Table1[c1], Table1[c2], Table1[c3], Table1[c4], Table1[c5] }
RETURN
    MINX ( Temp, [Value] )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I would add this as a native column using Query Editor.  

 

Click on "Add Custom Column", and paste in this formula.  Note that you may need to adjust it depending on the names of your 5 columns.

 

List.Min( { [C1], [C2], [C3], [C4], [C5] }  )

 

This formua first generates a list of values, using the 5 columns.  It uses Curly Braces {} to say it's a list.

 

Then List.Min finds the smallest value of that list.

 

Hope this helps,

 

~ ChrisH 

jenniferr's avatar
jenniferr
Regular Visitor
2 years ago

perfect solution!  thank you