finding max and min values based on 2 or more criteria in a table

[ArleneJose]

Hi there,

Can somebody please help me pick up the max and min values from a table summarize by month-year and locations?  I created a calender table linked to the data table that can show data by month-year.

I tried to create a measure using MIN and AllEXCEPT, but the result is showing me min and max amounts per location regardless of date.  

THis was the measure I created:   MinValue=CALCULATE(MIN(Data[Amount]),ALLEXCEPT(Data[date],)ALLEXCEPT(Data[Location])

My table looks like this:

date	Location	Amount
1/04/2018	Brito	-15
20/04/2018	Brito	10
5/04/2018	Brito	14
5/05/2018	Brito	2
6/05/2018	Brito	16
29/05/2018	Brito	-22

Expected view result:

Month-Year	Location	Min	Max
Apr-18	Brito	-15	14
May-18	Brito	-22	16

thanks in advance,

ArleneJ

[v-jiascu-msft]

Hi ArleneJ,

Actually, we don't need a measure in your scenario. Please check out the demo in the attachment.

Best Regards,

Dale

[ArleneJose · Accepted solution]

awesome Dale.  thanks.