Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate with a date range?

Hello,    I am trying to replicate what a "SUMIFS" forumla would do in excel with a date range. I have 2 main data tables one that has actual promoted sales units and one that has planned promoted ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I solved this with a "Datesbetween" formula

     

    Actual Promo Units = CALCULATE([Promo Units CY], DATESBETWEEN('Date'[Date],MAX('Trade Plan 2019'[Start Date]),max('Trade Plan 2019'[End Date])))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-yuta-msft  the formula didn't bring in any values - it's all blank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I solved this with a "Datesbetween" formula

 

Actual Promo Units = CALCULATE([Promo Units CY], DATESBETWEEN('Date'[Date],MAX('Trade Plan 2019'[Start Date]),max('Trade Plan 2019'[End Date])))