I have a formula which will gives me closing stock till max date.
For example i need to calculate Average closing stock for 100 days. My formula will gives me the stock on 100th days. Is there any way to calculate Day1 closing stock+day2 Closing stock+day 3 closing stock.....till 100th day.
Thanks in advance.
Depending on your datastructure, you should take a look into the RangeAvg function in combination with Above().
See the "example with expression" part in the above link.
So if you have a daily dimension, you should be able to use the following.