cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rjg2g11 Regular Visitor
Regular Visitor

Minimum Value across multiple columns

 

Hello,

 

I am trying to create a column that picks out the minimum value from a number of columns. 

 

I have posted a table below with my desired outcome

 

Can someone advise?

 

Many Thanks

 

 

IDABCDEFGDesired Column
3618509819.983914.70000C
368551672229.51801817.818.5F
3493843025.9827.9817.80020.517G
3800155423.627.316.2816.200D
32315810027.116.70016.516.1G
3212523922.12716.40016.117.8F
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Minimum Value across multiple columns

@rjg2g11

 

 

After unpivoting your Letter Columns, you can use following MEASURE to get the desired Output

 

DesiredResult =
VAR MinValue =
    CALCULATE ( MIN ( TableName[Value] ), TableName[Value] <> 0 )
RETURN
    CONCATENATEX (
        FILTER ( TableName, TableName[Value] = MinValue ),
        TableName[Attribute],
        ", "
    )
4 REPLIES 4
Super User
Super User

Re: Minimum Value across multiple columns

Easiest thing to do would be to unpivot your letter columns. At that point, the problem is trivial.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Re: Minimum Value across multiple columns

make sure to specify that you dont care about zeros, as in your dataset, the lowest value is zero, even though its your outcome in the sample data specifies you want the lowest value that is greater than zero.

Super User
Super User

Re: Minimum Value across multiple columns

@rjg2g11

 

 

After unpivoting your Letter Columns, you can use following MEASURE to get the desired Output

 

DesiredResult =
VAR MinValue =
    CALCULATE ( MIN ( TableName[Value] ), TableName[Value] <> 0 )
RETURN
    CONCATENATEX (
        FILTER ( TableName, TableName[Value] = MinValue ),
        TableName[Attribute],
        ", "
    )
Super User
Super User

Re: Minimum Value across multiple columns

@rjg2g11

 

See the attached file here

With your sample data

 

 

6001.png