Returning a value if cells are duplicate based on condition

Question

Hello PBI community,I need your help to create a column that returns only one value based on MAX Quantity, below is an example.current data:Condition. &nbsp; Quantities.Absd1011. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Absd1213. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Absd1314. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Absd1011. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Absd1011. &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp;Desired data:Condition. &nbsp; Quantities. &nbsp;Duplication check.&nbsp;Absd1011. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; True.&nbsp;Absd1213. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; True.&nbsp;Absd1314. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; True.&nbsp;Absd1011. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blank/False.&nbsp;Absd1011. &nbsp; &nbsp; &nbsp; &nbsp; -1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Blank/False.&nbsp;So basically i just need to return only one value for distinct "Condition" with MAX Quantity "which is usually 1 or -1".And in case two rows met the criteria to only take one row randomly.I was able to create the code for first part but I'm stuck in the second part which is most important for my case where i have to pick only one row randomly.Thanks in advance:)

ryan_mayu · Accepted Answer

what about use the group by function in the PQ?

Forum Discussion

Returning a value if cells are duplicate based on condition

2 Replies

Related content

MAXX Returning duplicate values

RANKX Formula Returning Duplicate Ranks

Duplicate ranking

remove duplicate value within a row

Return Duplicates when Criteria Matched