Page 1 of 1

Group Start and End Dates

Posted: Tue May 08, 2018 6:50 am
by Wrencher
How would I get the max DATE and min DATE from this subset?

Code: Select all

=CALCULATE(sum(MTILE[QtyCnsmp]),DATESBETWEEN(MTILE[Posting Date],Date (Year(today())-1,Month(today())+1,Day(today())),Date (Year(today())-1,Month(today())+2,Day(today()))))


Thank you!