Forum Discussion

STS_Joshua's avatar
STS_Joshua
Helper II
6 years ago
Solved

Running Total

Hi All,   I have an issue I could use some help with. I need to create a running total measure instead of the below.   Where that has +'s and -'s for each month, this data isn't really tota...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try Like this . Adding Inventory from day one.  I have used the same table. Use appropriate tables 

     

     

    Inventory till date = 
Var _min_date_for_inventory = CALCULATE(maxx(all('Date'[Date Filer]),'Date'[Date Filer]))
Var _Todays_date=CALCULATE(maxx(ALLSELECTED('Date'[Date Filer]),'Date'[Date Filer]))

Var _inventory= CALCULATE(sum(Sales[Sales Amount]),Sales[Sales Date]<=_min_date_for_inventory)
Var   Sale_till_tody =CALCULATE(sum(Sales[Sales Amount]),filter(sales,Sales[Sales Date]<=maxx(Sales,Sales[Sales Date].[Date])))
Var   purchase_till_tody =CALCULATE(sum(Sales[Sales Amount]),filter(sales,Sales[Sales Date]<=maxx(Sales,Sales[Sales Date].[Date])))

return
_inventory+Sale_till_tody-purchase_till_tody

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Share the link from where i can download your PBI file.