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 ,

 

Kindly take a look on this PBIX example(https://ufile.io/twxcj922)

Due to this issue, I have double count the transactionnumber even I have put distinctcout on it. 

Transaction number is unique for most of time. But there will somehow show in some special case.