WPA Expiry Analysis getting MAX Function Error

Hi Anonymous 

Based on what you have provided, here are the only suggestions I can give you.

Please try to change the code to:

VAR LatestExpirationDate =
    MAXX (
        VALUES ( 'All'[Employee Name] ),
        MAXX (
            ADDCOLUMNS (
                VALUES ( 'All'[Employee Name] ),
                "WPA1 Latest Date", 'All'[WPA1 Latest Date],
                "WPA3 Latest Date", 'All'[WPA3 Latest Date],
                "WPA4 Latest Date", IF('All'[Role] = "FLOOR LEADER", 'All'[WPA4 Latest Date], BLANK()),
                "WPA5 Latest Date", 'All'[WPA5 Latest Date],
                "WPA9 Latest Date", 'All'[WPA9 Latest Date],
                "WPA10 Latest Date", 'All'[WPA10 Latest Date],
                "WPA11 Latest Date", 'All'[WPA11 Latest Date],
                "WPA12 Latest Date", 'All'[WPA12 Latest Date],
                "WPA14 Latest Date", 'All'[WPA14 Latest Date],
                "WPA15 Latest Date", 'All'[WPA15 Latest Date]
            ),
            [Value]
        )
    )
RETURN
    IF (
        LatestExpirationDate < MAXX(VALUES('All'[Employee Name]), 'All'[WPA EXPIRY]),
        IF (
            DATEDIFF ( LatestExpirationDate, MAXX(VALUES('All'[Employee Name]), 'All'[WPA EXPIRY]), DAY ) <= 30,
            "Expires Soon",
            "Expired"
        ),
        "Not Expired"
    )

If you can, please provide your pbix file and be careful to remove sensitive data.

Regards,

Nono Chen

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