Forum Discussion
Solved
Label duplicate values based on another column
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 "K...
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/@HowtosolveprobemRegards
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 .
Thank you very much!