Show missing articles in table

Hi joshua1990 

You could do it in Power Query like this:Master Table in Excel

Transaction Table

Start a merge query action from transaction table with "as New"

Execute a left anti join

now you get the Articles which are only in the transactions and not in the master

name the query "Missing items"

if you want to have unique values reduce the dataset to the columns you need and then remove all the duplicates

Result (when you reduce set on the articles only then you have unique values without the calendar week)

afterwards you can load the data into power Bi and you can see the missing items

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn