Reply
Frequent Visitor
Posts: 6
Registered: ‎08-14-2017
Accepted Solution

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?

 

interla.PNG

 


Accepted Solutions
Highlighted
New Contributor
Posts: 583
Registered: ‎04-02-2017

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

@arveseba Please use this as "New Column"

 

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

image.png

 

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

 

View solution in original post


All Replies
Highlighted
New Contributor
Posts: 583
Registered: ‎04-02-2017

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

@arveseba Please use this as "New Column"

 

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

image.png

 

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