Inventory Count from Count in a Date Range

[BrandonG]

I have two tables, Date and Inventory. Inventory is a distinct look at inventory with a New date and Sold Date attached. Is there a way to take the Date from the Date Table and count how many times it shows up in the New and Sold ranges. This will give me how much was in inventory on those days.

Inventory Table

ID	New	Sold
47883602	6.23.2022	7.01.2022
41622522	7.01.2022	7.01.2022
45181882	5.20.2022	7.02.2022
48105302	7.01.2022	7.03.2022
43855572	6.08.2022	7.05.2022
50316242	6.30.2022	7.05.2022
50301082	7.01.2022	7.05.2022
50396872	7.01.2022	7.05.2022
50137862	7.05.2022	7.05.2022
41236432	5.16.2022	7.06.2022

If I look at date 6/08 it would show 3 in inventory, 7/01/2022 would show 9 in inventory

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[BrandonG]

Thank you, this solved a weeks worth of headaches

[Ashish_Mathur]

You are welcome.

[vicky_]

You can try just use a simple matrix with [New] as a row, and then the count of [New] as the value. And then do the same for Sold.