Daily Inventory Tracking

[BrandonG]

I am tracking car lot inventory. I have a unique identifier for each car, a date the car entered the lot and a date the car was sold.

 Example

Lot Number	New	Sold
159863	12/15/2022	1/12/2023
458965	7/23/2022	11/8/2022
896598	8/19/2022	1/6/2022
256325	1/7/2023
569852	8/3/2022	8/29/2022

Is there a was to use these 2 dates so can could look back at a date in time and see how many cars were on lot for a specific day.

[Anonymous · Accepted solution]

Hi @BrandonG ,

You might consider creating an unconnected calendar table for the slicer.

Then create a measure like this:

Number of cars =
VAR _selected_date =
    SELECTEDVALUE ( 'Calendar'[Date] )
VAR _no =
    COUNTROWS (
        FILTER (
            ALL ( 'Table' ),
            'Table'[New] <= _selected_date
                && (
                    'Table'[Sold] > _selected_date
                        || 'Table'[Sold] = BLANK ()
                )
        )
    ) + 0
RETURN
    _no

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Urubugala]

How would you do this if you needed that count of vehicles by like make, model, fuel, (basically across many categories), etc.?  I will need to plot this on a chart for every day going back years.  

I'm new to Power BI and truly appreciate the help!