Label duplicate values based on another column

[Lee5150]

Hi all,

I have a 'Name' column that contains duplicate values. I'd like a new column that either says "Kitchen" or "Utililty" based on the value in the qty column. The higher number should say "Kitchen", and the lower "Utility".

Name	Qty	Custom Column
ABC	10	Utility
XYZ	30	Kitchen
XYZ	15	Utility
ABC	27	Kitchen

The name column will only ever have 2 of the same entry, never more. So one will always say "Kitchen" and one will always say "Utility", based on the qty column.

Can anyone help me achieve this please?

Many thanks

[Thennarasu_R]

@Lee5150 

I hope this caluculation will help u to Yours requirements .Better U can use this calculation I'm getting similar output what u required.

rank = var AA=Check[Char]

Var _BB=

RANKX(FILTER(ALL(Check),Check[Char]=EARLIER(Check[Char])),Check[Value],,ASC,Dense)

Return

IF(_BB=1,"Kitchen",IF(_BB=2,"Utility"))

Thanks ,
Thennarasu 

Did I answer your Question? Mark Accepted as a solution .

[Lee5150]

Thank you very much!

[qqqqqwwwweeerrr · Accepted solution]

Hi @Lee5150 

I have one quick question so name alway will only two qty or more than that? as per the give data i have created the custom column

You can achive this by create custom colum measure 

custome Column =

var maxvalue = CALCULATE(MAX('Table'[Qty]),FILTER('Table','Table'[Name] = EARLIER('Table'[Name])))

return IF('Table'[Qty] = maxvalue,"Kitchen","Utility")
Here is my output 

Here is my another example hope your all case is covered in this

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

[Lee5150]

This works perfectly! Thank you so much