Max or Min with Group By not working correctly with multiple years

[danyeungw]

With the following data, I want to get the max and min for January by year. It worked correctly if there is only year 2022 data. With January 2023 data, January 2022 Max and Min shows January 2023 Max and Min. I need help on the measures. Thank you.

I created 

Max = MAXX(GROUPBY(ALLSELECTED('DS'),'DS'[release_date].[Year],'DS'[release_date].[Month],'DS'[release_date].[Day]),DS[Amout])

Min = MINX(GROUPBY(ALLSELECTED('DS'),'DS'[release_date].[Year],'DS'[release_date].[Month],'DS'[release_date].[Day]),DS[Amout])

Expect:

		Min	Max
2022
	January	22.98	3164.46	(the sum of 1/3/2022)
2023
	January	20.05	1904.51	(the sum of 1/3/2023)

Data:

2022
	January
	1	502.38
	1	660.98
	1	596.21
	2	533.24
	2	804.60
	3	576.31
	3	795.23
	3	713.29
	3	412.18
	3	667.45
	4	251.25
	5	655.53
	6	401.15
	7	817.37
	8	22.98
	9	840.72
	10	556.28
	11	245.58
	12	159.84
	13	795.21
	14	588.45
	15	742.38
	16	75.02
	17	846.54
	18	887.91
	19	529.19
	20	99.52
	21	354.87
	22	529.00
	23	23.74
	24	23.93
	25	380.30
	26	886.47
	27	859.53
	28	298.31
	29	341.57
	30	818.30
	31	537.09
2023
	January
	1	718.13
	1	487.77
	1	260.99
	1	360.01
	2	247.31
	2	40.75
	3	874.91
	3	870.78
	3	158.82
	4	847.42
	5	204.94
	6	572.24
	7	140.25
	8	100.32
	9	453.19
	10	271.19
	11	776.77
	12	527.33
	13	231.27
	14	264.02
	15	61.35
	16	236.79
	17	240.69
	18	780.17
	19	792.64
	20	391.63
	21	783.50
	22	405.67
	23	744.64
	24	439.95
	25	20.05
	26	581.98
	27	861.77
	28	497.36
	29	457.56
	30	405.20
	31	848.13

[danyeungw]

The data table hierarchy is release_date. Thanks. 

[FreemanZ]

hi @danyeungw 

your dataset doesn't include [release_date] column, please consider enrich your dataset to well reflect your challenges.