WPA Expiry Analysis getting MAX Function Error

Question

For this employee, whose WPA expires on 09-08-2024, I need to search in columns WPA 1, WPA 3, WPA 4 (with a role filter for Floor Leader), WPA 5, WPA 9, WPA 10, WPA 11, WPA 12, WPA 14, and WPA 15 to retrieve the latest date and compare it with the WPA expiry date. If the date is before the WPA expiry date, it's marked as expired. If it's within 30 days of expiry, it's labeled as expiring soon. Only the entries in WPA 4 column corresponding to the Floor Leader role are considered. I'll implement this using DAX&nbsp;Example Data :Employee&nbsp; &nbsp; Role&nbsp; &nbsp; &nbsp; WP1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WP2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WP3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WP4&nbsp; &nbsp; &nbsp; &nbsp; WP5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WP6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WPAEXPIRY&nbsp; &nbsp; Adam&nbsp; &nbsp;TERMINAL&nbsp; 05-12-23&nbsp; &nbsp; 10-08-23 22-08-23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10-08-23&nbsp; &nbsp; &nbsp; 10-08-23&nbsp; &nbsp; &nbsp; &nbsp; 09-08-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FLOOR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10-08-23&nbsp;&nbsp;I Have created dax&nbsp; for&nbsp;VAR LatestExpirationDate =&nbsp; &nbsp; MAXX (&nbsp; &nbsp; &nbsp; &nbsp; VALUES ( 'All'[Employee Name] ),&nbsp; &nbsp; &nbsp; &nbsp; MAXX (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ROW (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA1 Latest Date", 'All'[WPA1 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA2 Latest Date", 'All'[WPA2 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA3 Latest Date", 'All'[WPA3 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA4 Latest Date", 'All'[WPA4 Latest Date- for Terminal],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA5 Latest Date", 'All'[WPA5 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA9 Latest Date", 'All'[WPA9 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA10 Latest Date", 'All'[WPA10 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA11 Latest Date", 'All'[WPA11 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA12 Latest Date", 'All'[WPA12 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA14 Latest Date", 'All'[WPA14 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "WPA15 Latest Date", 'All'[WPA15 Latest Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'All'[WPA1 Latest Date], 'All'[WPA2 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'All'[WPA3 Latest Date], 'All'[WPA4 Latest Date- for Terminal],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'All'[WPA5 Latest Date], 'All'[WPA9 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'All'[WPA10 Latest Date], 'All'[WPA11 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'All'[WPA12 Latest Date], 'All'[WPA14 Latest Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'All'[WPA15 Latest Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )RETURN&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; LatestExpirationDate &lt; MAXX(VALUES('All'[Employee Name]), MAX('All'[WPA EXPIRY])),&nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATEDIFF ( LatestExpirationDate, MAXX(VALUES('All'[Employee Name]), MAX('All'[WPA EXPIRY])), DAY ) &lt;= 30,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Expires Soon",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Expired"&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; "Not Expired"&nbsp; &nbsp; )&nbsp;but i am getting Error&nbsp;Too many arguments were passed to the MAX function. The maximum argument count for the function is 2.&nbsp;Looking for support thanks in advance&nbsp;😊

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Based on what you have provided, here are the only suggestions I can give you.
&nbsp;
Please try to change the code to:
&nbsp;
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 &lt; MAXX(VALUES('All'[Employee Name]), 'All'[WPA EXPIRY]),
        IF (
            DATEDIFF ( LatestExpirationDate, MAXX(VALUES('All'[Employee Name]), 'All'[WPA EXPIRY]), DAY ) &lt;= 30,
            "Expires Soon",
            "Expired"
        ),
        "Not Expired"
    )

&nbsp;
If you can, please provide your pbix file and be careful to remove sensitive data.
&nbsp;
Regards,
Nono Chen
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

WPA Expiry Analysis getting MAX Function Error

1 Reply

Related content

Cohort analysis

AI Functions error for text analysis

loop function to get free dates

Retention analysis

loop function to get free dates