List parts with number of days with no stock?

[markblom]

Hi!

I am looking for a way to count the number of days in a period where a part has had no stock.

Below you will find a short summary of the related tables:

Parts:

Partnumber

Description 

Stock:

Stockdate

Partnumber

Quantity

Date:

Date

If a part has had no stock on a certain date there will be no record in the Stock table for that combination of Partnumber and Stockdate.

I would like to create a visual based on a table with all parts and in a column I would like to show the number of days in that period where there was no stock for that part. What would be the best way to do so?

[Fowmy · Accepted solution]

@markblom 

Add the Part Number from the PArts table and the following measure to table visual:

Days Without Parts = COUNTROWS (Dates) - COUNTROWS (Stock)

[mlfblom]

I am struggling with my account to this community so this reply comes from a different user.

Anyway: thanks for the solution!

Mark