Argument '4' in CALCULATE function is required.

[cnestg8r]

Hi,

I am trying this as a calculated column:

=if(CALCULATE(COUNTROWS((Sales)),'Calendar'[Date]>=Sales[start],'Calendar'[Date]<=Sales[end],)>0,1,0)

but I get the subject error message. Sales[start] end [end] are also calculated columns.

Help is appreciated...

[Anonymous · Accepted solution]

Rewrite your code to this:

=if(CALCULATE(COUNTROWS((Sales)),'Calendar'[Date]>=Sales[start],'Calendar'[Date]<=Sales[end])>0,1,0)

I only deleted the last comma in the CALCULATE function call.

[cnestg8r]

Good catch. I need better glasses.

Many thanks