Forum Discussion

BrandonG's avatar
BrandonG
New Member
3 years ago
Solved

Daily Inventory Tracking

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 NumberNewSold
15986312/15/20221/12/2023
4589657/23/202211/8/2022
8965988/19/20221/6/2022
2563251/7/2023 
5698528/3/20228/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.

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Urubugala
      Regular Visitor
      3 years ago

      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!