Forum Discussion

cnestg8r's avatar
cnestg8r
Regular Visitor
9 years ago
Solved

Argument '4' in CALCULATE function is required.

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[...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
cnestg8r
Regular Visitor
9 years ago

Good catch. I need better glasses.

Many thanks