How to create a measure Max values based on multiple columns

Question

Hi
I am trying to create a measure which shows Max values based on 4 columns. Below is the table format

But I would like create a measure which shows data in below format

There are other columns apart from these 4 columns but I would like to see Max value based on these columns only.

Please advise..

Answer 1

Hi @Learner DAX

It's not really clear to me if you're after a Power Query of Power Pivot solution... Assuming it's Power Query and with the table you exposed:

let  
    ......,  
    PreviousStepName = ...,  
    GroupedRows = Table.Group(PreviousStepName, {"ColumnA"},  
        {"GRP_ColA", (t)=>  
            Table.RemoveColumns(  
                Table.SelectRows(  
                    Table.AddColumn(t, "IsMax", each  
                        [Value] = List.Max(Table.Column(t,"Value")),  
                        type logical  
                    ),  
                    each [IsMax]  
                ),  
                {"IsMax"}  
            ),  
            type table  
        }  
    ),  
    CombinedNestedTables = Table.Combine(GroupedRows[GRP_ColA])  
in  
    CombinedNestedTables  

Any question please let me know and if this solves your problem please mark this reply as answer to help others with a similar scenario. Thanks in advance & Nice day...

EDIT A sample is available here

Answer 2

Hi @Learner DAX

A simplified version of the previous proposal:

let  
    ....,  
    PreviousStepName = ...,  
    GroupedRows = Table.Group(PreviousStepName, {"ColumnA"},  
        {"GRP_ColA", (t)=>  
            Table.SelectRows(t, each [Value] = List.Max(Table.Column(t,"Value"))),  
            type table  
        }  
    ),  
    CombinedNestedTables = Table.Combine(GroupedRows[GRP_ColA])  
in  
    CombinedNestedTables  

Sample updated (same link)

And BTW, what do you expect in the following situation?: