Forum Discussion

Zvekanm's avatar
Zvekanm
Frequent Visitor
3 years ago

Running total

Hi ,       i have small issue with running total.  Im calculating stock value in warehause from 2022 till today, and its working. For quantities vorking with no mistake, but for value not. Pro...
Need Help
Zvekanm's avatar
Zvekanm
Frequent Visitor
3 years ago

hi,

 

running total

Stock Value EUR =
VAR _result=
CALCULATE(
   [Starting Value]+[Total Value 101]+[Total Value 102]-[Total Value 122]+[Total Value 123]-[Total Value 261]+[Total Value 262]-[Total Value 711]+[Total Value 712]-[Total Value 291]+[Total Value 309]-[Total Value 601]+[Total value 602],
    FILTER(ALLSELECTED('DIM Calendar'[Transaction_Date]),
    'DIM Calendar'[Transaction_Date]<=MAX('DIM Calendar'[Transaction_Date])
    )
    )/117.5
    return _result
 
one of the meassure
Total Value 101 =
CALCULATE(
SUM('MSEG Material MvM'[Loc.curr.amount]),
filter('MSEG Material MvM','MSEG Material MvM'[MvT]=101)
)
 
depends of type of movement (101,102...)its adding or subtracts on stock value
Value is from extract table in SAP

 

 
eliasayyy's avatar
eliasayyy
Memorable Member
3 years ago

hmm looks complicated try 

CALCULATE(
   [Starting Value]+[Total Value 101]+[Total Value 102]-[Total Value 122]+[Total Value 123]-[Total Value 261]+[Total Value 262]-[Total Value 711]+[Total Value 712]-[Total Value 291]+[Total Value 309]-[Total Value 601]+[Total value 602],
    'DIM Calendar'[Transaction_Date]<=MAX('DIM Calendar'[Transaction_Date]
    )
    )/117.5
  • Zvekanm's avatar
    Zvekanm
    Frequent Visitor
    3 years ago

    eliasayyy 

     

    if you have more simple solution... then you are my best friend 😄

    problem is that i must track stock value on weekly base of each material.

    then material group... procurment type.. supplier..

    lot of demands from my manager.

    this is only solution that work for me.

    plus i need every type of movement in other calculation..

    • Zvekanm's avatar
      Zvekanm
      Frequent Visitor
      3 years ago

      and top of that...

      Forecast..

      addind each PO to stock for forecasting stock value in next period - consuption 

      😄

      easy task for me

    • eliasayyy's avatar
      eliasayyy
      Memorable Member
      3 years ago

      well i cant help out much without seeing datasets but if you just want to get the stock vlue per week , powerbi automatically does that 
      your measure above will sum up all values until today example if yesterday i had 10$ and today i had 30$ the measure will return 
      10 on yesterday and 40 on today if you just want to return the price per day just use a simple max function