Custom column that calculates the max date from a group of values from another field

[Anonymous]

Example:

id	group	date	custom
1	apples	7/1/2022	7/2/2022
2	apples	7/2/2022	7/2/2022
3	bananas	7/1/2022	7/3/2022
4	bananas	7/3/2022	7/3/2022

[vapid128 · Accepted solution]

calculate(max([date]),ALLEXCEPT([group])

[daXtreme]

How to Get Your Question Answered Quickly - Microsoft Power BI Community

[vapid128 · Accepted solution]

calculate(max([date]),ALLEXCEPT([group])

[Anonymous]

Thanks. Is there a way to use the above but compare each row's custom column against the date column and return a boolean 1,0 if they equal each other?

[vapid128 · Accepted solution]

calculate(max([date]),ALLEXCEPT([group]) = [date]