Forum Discussion

PowerBI123456's avatar
PowerBI123456
Icon for Post Partisan rankPost Partisan
6 years ago

Checking if right code was deleted

Hi, need some help and hopefully this makes sense. I have 2 different tables below. The first table is the data. The second table tells you the combination of codes that cannot exist together for the...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

So do the data have Code1, Code2?  If not, is there some way to differentiate the intial code vs the replacement code?  DateTime column?  Or is any combination of the two codes in either order always an error?

 

Regards,

Pat

 

PowerBI123456's avatar
PowerBI123456
Icon for Post Partisan rankPost Partisan
6 years ago

mahoneypat no the data does not have Code 1, Code 2. I think your code is right, but I can't create a relationship since its many to many.