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.

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

Dear amitchandak ,

Thanks for your response.

Measure you given will show all result in duplicate. Because I have different day and time for one JobN. And I will have different row. 

My question is, JobN is only have one TransactionN.

But if different JobN sharing the same TransactionN. New measure will result it as 'Duplicate'