Forum Discussion
Solved
Add Sum all the previous elements to a date
Hello, I would like the sum of hours for a month with previous months. my table looks like this I would like to get something like this ...
_hours = CALCULATE(SUM('Table'[h]),ALLEXCEPT('Table','Table'[Month])) Comm_Hours = CALCULATE(SUM('Table'[h]),FILTER(ALL('Table'[Month]),'Table'[Month]<=MAX('Table'[Month])))
_hours = CALCULATE(SUM('Table'[h]),ALLEXCEPT('Table','Table'[Month]))
Comm_Hours = CALCULATE(SUM('Table'[h]),FILTER(ALL('Table'[Month]),'Table'[Month]<=MAX('Table'[Month])))
Thank you very much, everything works beautifully