Calculated column that compares multiple columns and returns latest date/ highest value

[HMK273]

Hello,

I'm trying to create a calculate/measure column which can find the recent date of 4 columns (C1, C2, C3, C4) and avoid empty values. As what I've done in Excel in Power Bi tables (not queries) by finding the recent date of 4 columns (C1, C2, C3, C4) and avoiding empty values.

Thanks in advance.

[rsbin · Accepted solution]

@HMK273 ,

This Calculated Column should work for you:

MaxDate = MAX([C4], ( MAX( [C3], ( MAX( [C1], [C2] )))))

Regards,

[HMK273]

@rsbinThank you very much, it works.