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[start] end [end] are also calculated columns.

 

Help is appreciated...

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.

2 Replies

  • 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