If date is between 2 dates that sum

Question

Hello,&nbsp;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&nbsp;

liviolanzo · Accepted Answer

try this (not tested but it should work)&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;'Table1'[Avg&nbsp;per&nbsp;Date]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;'Table1'[Start&nbsp;date]&nbsp;&lt;=&nbsp;EARLIER&nbsp;(&nbsp;'Calendar'[Date]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;'Table1'[End&nbsp;Date]&nbsp;&gt;=&nbsp;EARLIER&nbsp;(&nbsp;'Calendar'[Date]&nbsp;))

Forum Discussion

If date is between 2 dates that sum

2 Replies

Related content

Find Most Recent Date Relative to another Date Column in Power Query

Date hierarchy

Service Date

Date Slicer not Responsive to Calculated Date Table

Power Query dates