Forum Discussion
PowerBI123456
Post Partisan
Post PartisanChecking 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...
mahoneypat
Microsoft Employee
Microsoft EmployeeThe column 1 codes are taken into account through the relationship. Also, I saw in the first example rows had Code1 in the first value and for the deletion, and then Code2 for the new/correct one. I assumed (perhaps incorrectly) that it was a typo on the second set of example rows did not have 1 or 2 next to the codes. Please confirm my assumption was incorrect, and I can propose a different measure.
Regards,
Pat
PowerBI123456Post Partisan
Post Partisanmahoneypat Thanks! Forgot to mention it will be a many to many relationship if I do it that way. See below.