Forum Discussion

arveseba's avatar
arveseba
Frequent Visitor
7 years ago
Solved

Extracting value based on max value from another column from each subgroup

Hi, 

 

I want extract value based on max value from another column from each subgroup. I tried ALLEXCEPT(), MAX() and another functions in DAX, but still im not found solution.

 

The final solution should look like the "Line" column is the value from the "Operation" column, where the maximum value is from the Internal column.

An example solution is in the attachment.

Can anyone suggest how to solve this?

 

 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    arveseba Please use this as "New Column"

     

    Line = LOOKUPVALUE(Test07MaxValWithinGroup[Opeartion],
                   Test07MaxValWithinGroup[Internal],
                   MAXX(FILTER(Test07MaxValWithinGroup,Test07MaxValWithinGroup[Employee]=EARLIER(Test07MaxValWithinGroup[Employee])),Test07MaxValWithinGroup[Internal])
                   )

     

    Note - Please try to post the sample data in copiable format which makes life easier.

     

1 Reply

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    arveseba Please use this as "New Column"

     

    Line = LOOKUPVALUE(Test07MaxValWithinGroup[Opeartion],
                   Test07MaxValWithinGroup[Internal],
                   MAXX(FILTER(Test07MaxValWithinGroup,Test07MaxValWithinGroup[Employee]=EARLIER(Test07MaxValWithinGroup[Employee])),Test07MaxValWithinGroup[Internal])
                   )

     

    Note - Please try to post the sample data in copiable format which makes life easier.