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? Does someone could help me please?
Need Help

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    10 years ago

    It will be possible but you will need to add a calculated measure to your cube.  Are you using Tabular or Multidimensional?  Both will work but one will use DAX while the other will need an MDX formula.

  • MattAllington's avatar
    MattAllington
    Community 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).