Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@phamthanhhungks , Try a new column
new col =
var _year = year([Date])
return
maxx(filter(Table, [Category] = earlier([Category]) && year([Date]) = _year ) , [Value])
@phamthanhhungks , Try a new column
new col =
var _year = year([Date])
return
maxx(filter(Table, [Category] = earlier([Category]) && year([Date]) = _year ) , [Value])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |