Group Start and End Dates

Anything related to PowerPivot and DAX Formuale
Wrencher
Posts: 6
Joined: Thu Jan 19, 2017 2:37 pm

Group Start and End Dates

Postby Wrencher » Tue May 08, 2018 6:50 am

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!

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest