Forum Discussion
HMK273
3 years agoFrequent Visitor
Calculated column that compares multiple columns and returns latest date/ highest value
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.
HMK273 ,
This Calculated Column should work for you:
MaxDate = MAX([C4], ( MAX( [C3], ( MAX( [C1], [C2] )))))Regards,