Get max value by category in the period

[phamthanhhungks]

Dear all,

I'm beginner with Power Bi and would like to get the max value by category in the period (e.g. 01 year). Could you please advise me how to filter this value?

Currently, I'm only can find the max value from all datas and not able to filter the value in my range.

My data example as below:

Category	Value	Date	Max value
A	5.5	21/02/2023	6.7
A	6.7	21/01/2022	6.7
A	7.8	21/01/2021	6.7
B	7.0	21/02/2023	6.0
B	6.0	21/01/2022	6.0
B	2.5	21/01/2021	6.0
C	1.2	21/02/2023	1.6
C	1.6	21/01/2022	1.6
C	2.5	21/01/2021	1.6

Many thank for your help.

Best Regards,

Kenny NG

[amitchandak · Accepted solution]

@phamthanhhungks , Try a new column

new col =

var _year = year([Date])

return

maxx(filter(Table, [Category] = earlier([Category]) && year([Date]) = _year ) , [Value])

[phamthanhhungks]

Thank @amitchandak, this problem resolved.