cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HolDen
Helper II
Helper II

Highest value of duplicate

Hi,

 

i have 3 columns column 1 is unique, column 3 and 4 can have duplicates.

 

Now i need to add a column to identify which has the highest value in column 1 when its a duplicate.

 

Example:

IndexIdName
1A21red
2A21red
3A22green
4A23yellow
5A22green
6A24blue
7A21red
8A22green
9A24blue

 

I need to have the higehst value marked with yes in a caalculated column 4

 

IndexIdNameHighest value
1A21redNo
2A21redNo
3A22greenNo
4A23yellowYes
5A22greenNo
6A24blueNo
7A21redYes
8A22greenYes
9A24blueYes

 

Any idea to solve it? Any help is welcome 🙂

 

Regards

1 REPLY 1
Nathaniel_C
Super User I
Super User I

 

Hi @HolDen ,

Try this:

Highest value = 

var _curName = mycolor[Name]
var _curIndex = mycolor[Index]
var _calc = CALCULATE(MAX(mycolor[Index]),FILTER(ALLEXCEPT(mycolor,mycolor[Name]), mycolor[Name]=_curName))

return IF(_calc = _curIndex, "Yes", "No")

 

mycolor.PNG


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 





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

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors