Forum Discussion
Sum on a dynamic date range
Hello, I would like to calculate the sum on a dynamic date range, for example: For March 2019, the sum of material consumption must be: = Sum of material consumption (April 2018 to March 2019) An...
Hello:
Try the following formula:
MAT cost:= calculate([Sum of material consumption],datesinperiod(calendar[date],lastdate(calendar[date]),-1,year))
Good luck,
José Luis
Hello:
Try the following formula:
MAT cost:= calculate([Sum of material consumption],datesinperiod(calendar[date],lastdate(calendar[date]),-1,year))
Good luck,
José Luis
It worked perfectly for me. Thanks a lot!