If date is between 2 dates that sum

[Two34]

Hello,

I have two tables one that has start date, end date , average value per day and the other that has Calendar.

I want to create a column in the calendar table with the total averages per day.

For example in case of 02-Feb i need to look in all the rows where 02-Feb is in between [Start Date-End Date) and sum the Avg per Day.

I tried the formula in the print screen but I got an error.

Many Thanks

[LivioLanzo · Accepted solution]

try this (not tested but it should work)

=
CALCULATE (
    SUM ( 'Table1'[Avg per Date] ),
    'Table1'[Start date] <= EARLIER ( 'Calendar'[Date] ),
    'Table1'[End Date] >= EARLIER ( 'Calendar'[Date] )
)

[Two34]

Thanks for the help!