Forum Discussion
Solved
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 Thank...
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], ", " )
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],
", "
)