Show missing articles in table

[joshua1990]

Hi all!

I have a attribute master table that is mantained manually week by week. That means we add new articles per week in a excel sheet.

Article	Group
A	1
B	1

Then we have a transactional table that shows us the sales for each week. We compare both tables in excel to add new articles.

Article	Week	Value
A	47	50
C	47	50
A1	48	40

Now I would like to build that kind of process in power bi.

I would like to get displayed in a table new articles for each week.

How would you do that?

[Mikelytics]

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