I have contract start and end dates and a contract value.
I want to calculate the value of the contracts over time.
I’ve included a column in the table for Daily Sales Value and I’m incorporating the Events in Progress pattern.
I’m stumped on how to calculate the Value based on # days within the context
This is what I have so far
Sales in Progress = CALCULATE( [Daily Sales], FILTER( VALUES( Contracts[Date Off] ), Contracts[Date Off] <= MAX('Event Dates'[Date] )), FILTER ( VALUES( Contracts[Date On] ), Contracts[Date On]>= MIN('Event Dates'[Date]))) Daily Sales = SUM(DailyRate)
I need to be able to multiply Daily Sales by # days within the context
I’m sure I’ve seen a video doing this but I can’t seem to find it.