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 , there are no dates in your example. Can you share a better sample with the output? I think the date need to considered to call it duplicate

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

Dear amitchandak ,

 

My data as below,

Hope can create a column to indicate it is duplicate.

Suspossedly, One TransactionNumber is only have one JobNumber.

But as you can see, different jobnumber is sharing one TransactionNumber.