Forum Discussion

Two34's avatar
Two34
Frequent Visitor
7 years ago
Solved

If date is between 2 dates that sum

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 da...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    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] )
    )

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

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's avatar
Two34
Frequent Visitor
7 years ago

Thanks for the help!