Argument '2' in CALCULATE function is required.

[stellis]

I have the following code and get this error message:

Argument '2' in CALCULATE function is required.

CODE:

%PO_NEU = IF(

        ISFILTERED('07_DateTable'[Month Name]),

        CALCULATE(

                 SUM('01_DC_FactTable'[Cost]),

                 MONTH('07_DateTable'[Date]) = MONTH(MAX('07_DateTable'[Date]))

                 )/

        CALCULATE(

                SUM('10_PO'[PO]),

                MONTH('07_DateTable'[Date]) = MONTH(MAX('07_DateTable'[Date]))

                ),              

        CALCULATE(

                 SUM('03_Percent PO'[DC%PO * 100]),

        ))

I cannot figure out what is wrong.

Thanks a lot for your help!

[stellis]

Thanks so much!

[DOLEARY85]

No problem 🙂

[DOLEARY85 · Accepted solution]

Hi,

try taking out that last comma

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍