Forum Discussion

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Create measure and depend on whether it is duplicate

Dear Community,   I have data as below  JobN TransactionN New Column** J001 T001 J001 J002 T002 Duplicate TransactionN J003 T002 Duplicate TransactionN J004 T003 Duplicate...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  NickProp28 ,

     

    Here are the steps you can follow：

    1. Create calculated colunm.

    New Colunm = IF([JNC]=[TNC],[JobNumber],"Duplicate")

    2. Result.

    You can downloaded PBIX file from here.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

NickProp28 , Not very clear, what column you need. You can have column like this to check duplicate

If(countx(filter(Table,[TransactionN] = earlier(TransactionN)),[TransactionN])+0 >0, "Duplicate",[JobN])

Inside job duplicate

If(countx(filter(Table,[TransactionN] = earlier(TransactionN) && [JobN] = earlier(JobN)),[TransactionN])+0 >0, "Duplicate",[JobN])

 

 

You can have to combine unique column

 

Key = [JobN] & "-" & [TransactionN]

 

  • NickProp28's avatar
    NickProp28
    Icon for Post Partisan rankPost Partisan
    5 years ago

    Dear amitchandak ,

     

    Is it my reply and pbix has clear your doubt?
    If yes please kindly advice me on it. Appciate your time.