DAX funciton for initial sotck

Anonymous 

Here is some suggestion for you.

Create a new column to calculate stock and transfer sales to negative value.

newamount = 
VAR stock=CALCULATE(sum('Table'[amount]),FILTER('Table','Table'[month]<=EARLIER('Table'[month])))
return if('Table'[month]<>min('Table'[month])&&'Table'[type]="stock",stock,if('Table'[type]="sales",'Table'[amount]*-1,'Table'[amount]))

I did something about financial balance which is quite similar to your request. Hope this is helpful.

Anonymous , do have data for all the dates. If so you can use

https://docs.microsoft.com/en-us/dax/openingbalancemonth-function-dax

https://docs.microsoft.com/en-us/dax/closingbalancemonth-function-dax

openingbalancemonth(Sum(Table[Value]), Date[Date])
closingbalancemonth(Sum(Table[Value]), Date[Date])

closingbalancemonth last month =closingbalancemonth(Sum(Table[Value]), dateadd(Date[Date],-1, Month))To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184


Appreciate your Kudos.

Oh! I see... I just want to understand how do you got the total value on the first line of the beginning cash. I did balance but something is going wrong. If you can enlighten me I'll be really glad!