Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative sum between a date range from two different date ranges

Hello everyone,    This is my first time using the forum so hopefully I have disobeyed any rules, apologises in advance.    I am trying to sum an amount from one table based upon a date from anot...
  • Nathaniel_C's avatar
    6 years ago

    Hi Anonymous ,
    Try this : 

    Sum of Amounts = SUMX(Production,IF(Production[Production date]>MAX(mySecond[Install Date]),Production[Amount],0))




    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel