Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

HASONEVALUE Measure to remove duplicates

Hey guys, I need a bit of help. I am trying to get something like this using IF clause and hasonevalue and I am stuck 🙂 Can someone please help me or give a suggestion about using something else

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    First create an index column in Power Query Editor, then create a calculated column like below:

    Column3 = 
var _min = CALCULATE(MIN('Table'[index]),FILTER('Table','Table'[Column2]=EARLIER('Table'[Column2])))
return
IF('Table'[index]=_min,'Table'[Column2],BLANK())

     

    Best Regards,

    Jay

     

2 Replies

  • truptis's avatar
    truptis
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous -> Please brief us more about your requirement. What you are trying to achieve.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    First create an index column in Power Query Editor, then create a calculated column like below:

    Column3 = 
var _min = CALCULATE(MIN('Table'[index]),FILTER('Table','Table'[Column2]=EARLIER('Table'[Column2])))
return
IF('Table'[index]=_min,'Table'[Column2],BLANK())

     

    Best Regards,

    Jay