Forum Discussion

HMK273's avatar
HMK273
Frequent Visitor
3 years ago
Solved

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,

2 Replies

  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion

    HMK273 ,

    This Calculated Column should work for you:

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

    Regards,