Calculating Inventory using sales out and sales in

[guptav13]

Hi , I want a new measure calculated inventory in addition to the inventory like below.

I want to take January as starting inventory and then calculate subsequest months inventory. So suppose for a particular SAPID, COUNTRY, CFN combination  JAN  Inventory was 100, then the FEB calculated inventory should be (JAN INVENTORY for that SAP COUNTRY CFN combination - FEB SALESOUT for that SAP COUNTRY CFN combination + FEB SALES IN for that SAP COUNTRY CFN combination)

 https://drive.google.com/file/d/1Z_Y8ETTn0_iqON44f5_CstXQPOi4vjqI/view?usp=sharing 

[ImkeF]

Hi @guptav13 ,
if you transform your input data a bit before loading into the data model and include a transformation that reverts the sign of the "Sale Out"-figures, you could use a DAX running total measure on it.
If you need help with the transformation, please include usable sample data (

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... )

[Greg_Deckler]

@guptav13 Well, unfortunately this seems to be a scenario where you need "previous value" or, in other words, it is a recursive problem and DAX does not like that kind of thing. Previous Value (“Recursion”) in DAX – Greg Deckler

Power Query supports recursion but it's a pain and is ugly. @ImkeF @edhans 

(1) Fun with Graphing in Power BI - Part 5-by-5 | LinkedIn