Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 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
6 years agoNot applicable
LEGEND!!!!! KUDOS Nathaniel_C
Nathaniel_C
6 years agoCommunity Champion
Anonymous , you are welcome!