Argument '5' in CALCULATE function is required

Question

Hi I have below code but it returns an error that

"Argument '5' in CALCULATE function is required" and I am not sure what is wrong. Pls kindly advise. Thanks!

GMV LW =

Var CurrentYear =

If(

HASONEVALUE('Date'[ISO Year]),

values('Date'[ISO Year])

)

Var CurrentWeek =

If(

HASONEVALUE('Date'[ISO Weeknumber]),

values('Date'[ISO Weeknumber])

)

Var LastWeekPY =

CALCULATE(

Max('Date'[ISO Weeknumber]),

All('Date'),

'Date'[ISO Year] = CurrentYear - 1

)

Var Result =

if(CurrentWeek=1,

CALCULATE([GMV USD],

ALL('Date'),

'Date'[ISO Weeknumber]=LastWeekPY,

'Date'[ISO Year]=CurrentYear-1

),

CALCULATE([GMV USD],

ALL('Date'),

'Date'[ISO Weeknumber]=CurrentWeek-1,

'Date'[ISO Year]=CurrentYear,

)

Return

Result

mfelix · Accepted Answer

Hi&nbsp;GraceTCL&nbsp;,
&nbsp;
You have a comma after the last Date ISO YEAR you need to take it.

formula corrected below:
GMV LW =
VAR CurrentYear =
    IF ( HASONEVALUE ( 'Date'[ISO Year] ), VALUES ( 'Date'[ISO Year] ) )
VAR CurrentWeek =
    IF ( HASONEVALUE ( 'Date'[ISO Weeknumber] ), VALUES ( 'Date'[ISO Weeknumber] ) )
VAR LastWeekPY =
    CALCULATE (
        MAX ( 'Date'[ISO Weeknumber] ),
        ALL ( 'Date' ),
        'Date'[ISO Year] = CurrentYear - 1
    )
VAR Result =
    IF (
        CurrentWeek = 1,
        CALCULATE (
            [GMV USD],
            ALL ( 'Date' ),
            'Date'[ISO Weeknumber] = LastWeekPY,
            'Date'[ISO Year] = CurrentYear - 1
        ),
        CALCULATE (
            [GMV USD],
            ALL ( 'Date' ),
            'Date'[ISO Weeknumber] = CurrentWeek - 1,
            'Date'[ISO Year] = CurrentYear
        )
    )
RETURN
    result

Forum Discussion

Argument '5' in CALCULATE function is required

1 Reply

Related content

Argument '2' in CALCULATE function is required.

table as calculate argument

calculate with max() function

Argument 3 in CALCULATE function is required - syntax error?

Argument '4' in CALCULATE function is required.