Merging 2 tables if tuples dosn't exists

[FlorianLOCHT]

Hello,

I am quite a newbie at Power Bi and I am trying something weird 😅

I have 2 tables, first with backup report and Second one with backup infos (each day backup need to run)

Table1

BackupName	Days
Name1	Monday
Name1	Tuesday
Name2	Monday

Table2

BackupName	Monday	Tuesday	Wednesday
Name1	True	True	True
Name2	True	False	False

I am loking for something to know that backup Name1 don't run on wednesday because there is a "True" is colums

And this for every backupName exist in Table2 that I can't find in Table1

Hope I am clear enough

Thank's

[marcelsmaglhaes · Accepted solution]

Hey @FlorianLOCHT !

Take a look into the images bellow and follow the steps. If it helps, please mark this post as solved! 
Regards,
Marcel

STEPS
1. First of all, you need to unpivoted your table 2 

2. After that, you can use the Mergie Queries option

3. Try change the Join Kind. I choose the Rigth Outer Join to bring all data from table 2 and just the data thats matching from table 1.

4. Now, expanded the column table choosing the columns that you can bring on your table.

5. The result is a table that show to me the values that exists in table two but not in table 1.