Forum Discussion

ilyaadna's avatar
ilyaadna
Regular Visitor
3 years ago

Filter Duplicate rows based on a value in the column

I am new to POWERBI and thanks in advance for everyone's help. Here is my problem. I am trying to remove duplicates based on Scrap_Qty value. If Scrap_Qty=1, it shoud keep that row and filter any oth...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

ilyaadna , Try a new column like

Flag = 

var _cnt = countx(FIlter(Table, Table[Serial No] =earlier(Table[Serial No]) , Table[Serial No])

return

Switch(True() ,

Scrap_Qty in {0,1} , 1,

isblank(_cnt ) ,1 ,

_cnt=1, 1,

0)

 

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8