Forum Discussion

IS's avatar
IS
New Member
10 years ago

Inventory cube

Hello, I would like to use in the standard inventory cube the ending amount measure in order to follow in a graph total stock value date per date. It seems that is not possible to use this measure? Do...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

In DAX, the general measure pattern is as follows 

 

Inventory :=
CALCULATE (SUM ( Inventory[StockCount] ),
LASTNONBLANK (Calendar[Date],CALCULATE ( SUM ( Inventory[StockCount] ) )))

 

this is pattern will work regardless of there being a count for every date (it will find the last count).