How to refer to a previous value in a measure

[Anonymous2024_]

I have an availble stock for the current week. I want to calculate the +inbound and -outbound of the week to have current stock. This dynmacilly created current stock should be used as reference for the next week calculation [start of stock]. then again +inbound -outbound  
inbound and outbound are measures which have been created in severeal measures, no columns in a table. So, index is not possible here. 

How can I move the current stock week by week ? I would appreciate if you could help. 

[AnushaSri]

Hi,

You might create the following DAX to get the date of Previous week end date (Considering Monday as start of week and Sunday as Weekend).

PreviousWeekEnd = MAX(DimDate[Date])-WEEKDAY(MAX(DimDate[Date]), 2)

You can use the date value generated by the above Dax to filter current stock to look at the end of previous week. it would be some thing like this.

Calculate(CurrentStock, Date=PreviousWeekend)

Please accept this as solution and give Kudos if it helps to resolve your issue.

[Anonymous2024_]

Hi AnushaSri, 

thank you for the reply. 

I tried your suggestion but receive the following error

[AnushaSri]

create Previousweekend as a variable in your start of stock2 measure and then use it in calculate
Start of Stock2 =

Var x= MAX('DimDate.1'[Date])-WEEKDAY(MAX('DimDate.1'[Date]), 2)

Return CALCULATE([Total Questions], 'DimDate.1'[Date]=x)

[Anonymous2024_]

I have tried so many options but still no result, I can't figure it how to make it dynamically 😞 

Is there anyone who can support, plesae 

[Anonymous2024_]

I still have the wrong numbers. 

For the current week, everything works fine. I can take the results and bring it to next week as a starting point. But from there my "Current Stock" dosn't calculate right. 

Current Stock =

var currentDate = TODAY()

var CurrentDeliveries = [Current Week Stock]  //  [available stock]+ in - out 

var CurrentForecast = [Next week Stock]         // [start of stock] + in - out 

return

IF(MIN('Date'[Date])<currentDate,CurrentDeliveries,CurrentForecast)