Trying to Count Status Using Two Date Columns

[taylorb]

I am trying to find the status of products based on whether or not the date selected is between two date columns. Here is an example of the data:

Item	Manufactured Date	In Service Date	Out of Service Date
Product 1	1/1/2020	1/25/2020	2/6/2020
Product 2	1/23/2020	1/27/2020	2/10/2020
Product 3	2/3/2020	2/5/2020	3/1/2020
Product 4	2/1/2020	4/7/2020	4/15/2020

If I looked at a date, I want one visual for count of items in "Manufactured" (not yet in service) and a different visual for "In Service" (not yet out of service). So for the above data, if I looked at 2/5, I would have Product 1-3 "In Service" and Product 4 in "Manufactured"

[Greg_Deckler · Accepted solution]

@taylorb - Seems like you might want something like Open Tickets: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

[taylorb]

This looks like what I need. Thanks