Adding up values between specific dates.

[RafaelPerez]

My main table is composed mainly of and ItemID, a Store ID, a InitialStock from Monday of that week, Sales since Monday of that week, OtherMovements and Date.

The only data that is from the date of the row is Movements, and that's what I want to add up.

I'm trying to add all the movements from Monday of that week to the selected date. For example: If I select Thursday, it should add up all the info from Monday, Tuesday, Wednesday, and Thursday, and add it up to the InitialStock and Sales to get the Stock.
I cannot provide the data set because of working policies.

Every bit of help would be appreciated.

[dplr-rn · Accepted solution]

Do you mean monday of that week?
Use setanalysis and weekstart function.
something like below (using Max(OrderDate) because if no date is selected it will show latest week)

Sum( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=WeekStart(Max(OrderDate)))"}>} LineSalesAmount)

[RafaelPerez]

It worked pretty well, and used it as the base for other expressions, Thanks!

[dplr-rn]

happy to help