Forum Discussion

JoRose's avatar
JoRose
Frequent Visitor
2 years ago
Solved

Track Stock amount

Dear DAX/Power BI Community, I have the following issue. I want to record warehouse stock on a daily basis. To restrict the amount of new entries in the database, i want to record only those product...
  • some_bih's avatar
    some_bih
    2 years ago

    Hi JoRose I created two measure, based on your sample data, as following

    Adjust your proper fact / Calendar tables names and you should get output from Output (Date from Date table, not fact)

    1. Simple simple = SUM(factInventory[Quantity])

    2. Sum adjusted =
    IF (
        ISEMPTY ( factInventory ),
        CALCULATE ( [Simple simple] ,OFFSET ( -1,, ORDERBY ( 'Date'[Date] ), ) ),
        [Simple simple]
    )

     

    Output

     

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi JoRose what is your request?

You wrote " want to record only those products which quantity changed since the last update." so you want to flag something like calculate / include / exclude... provide expected output in table view (later you can do visuals)

  • JoRose's avatar
    JoRose
    Frequent Visitor
    2 years ago

    Hey some_bih, i have updated my post. What i need is a measure that can calculate the result the shown in the diargam.