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...
cumulative
multiple date tables
  • Nathaniel_C's avatar
    Nathaniel_C
    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

     

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
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

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

LEGEND!!!!! KUDOS Nathaniel_C 

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Anonymous , you are welcome!