HASONEVALUE Measure to remove duplicates

[Anonymous]

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

[Anonymous · Accepted solution]

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

[truptis]

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