Forum Discussion

Lee5150's avatar
Lee5150
Helper I
2 years ago
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...
Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    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

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Solution Sage
2 years ago

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's avatar
    Lee5150
    Helper I
    2 years ago

    This works perfectly! Thank you so much