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 "Kitchen", and the lower "Utility".

 

NameQtyCustom Column
ABC10Utility
XYZ30Kitchen
XYZ15Utility
ABC27Kitchen

 

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

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

4 Replies

  • Thennarasu_R's avatar
    Thennarasu_R
    Responsive Resident
    2 years ago

    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 .

  • 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