Forum Discussion

maheshsinha's avatar
maheshsinha
New Member
9 years ago

Inventory Movement Analysis from Single Table

Hi All   I am new to Power BI and trying to learn and implement it in my company   The issue is i do have a table in SQL in which i do have records as below Example Data StoreCode | EntryType |...
fhill's avatar
fhill
Resident Rockstar
9 years ago

Consider adding a Running Total Column as referenced in this link:

 

https://community.powerbi.com/t5/Desktop/Running-Total-DAX/td-p/41393

 

Here's my code based on your data:

Running Total COLUMN =
CALCULATE (
SUM ( 'sample'[ Qty] ),
ALLEXCEPT ( 'sample', 'sample'[ Item Code ] ),
'sample'[ Entry Date ] <= EARLIER ( 'sample'[ Entry Date ] )
)

 

You can then graph this runnign total to show Inventory over time...  (I would suggest a Store Level filter, as I didn't exclude StoreCode from the running totals.)