Create Calculated column based on Multiple IF Conditions and MAXX between two tables

Hi rkottap ,

Maybe you can try to modify formula like below and create calculated column:

Output =
VAR MaxValue =
    MAXX (
        FILTER (
            Table2,
            Table2[Epic Link] = Table1[Epic Link]
                && Table2[ABC Review] = Table1[ABC Review]
        ),
        SWITCH (
            TRUE (),
            Table1[ABC Review] = "ABC1", Table2[Planning1],
            Table1[ABC Review] = "ABC2", Table2[Planning2],
            Table1[ABC Review] = "ABC3"
                && Table2[XYZ1 Date] > Table2[ABC2 Date], Table2[XYZ1 Date],
            Table1[ABC Review] = "ABC3"
                && Table2[XYZ1 Date] < Table2[ABC2 Date], Table2[ABC2 Date],
            Table1[ABC Review] = "ABC4"
                && Table2[XYZ2 Date] > Table2[ABC3 Date], Table2[XYZ2 Date],
            Table1[ABC Review] = "ABC4"
                && Table2[XYZ2 Date] < Table2[ABC3 Date], Table2[ABC3 Date],
            Table1[ABC Review] = "ABC5"
                && Table2[XYZ3 Date] > Table2[ABC4 Date], Table2[XYZ3 Date],
            Table1[ABC Review] = "ABC5"
                && Table2[XYZ3 Date] < Table2[ABC4 Date], Table2[ABC4 Date],
            BLANK ()
        )
    )
RETURN
    MaxValue

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.