Forum Discussion

HelloPowerBi's avatar
HelloPowerBi
Frequent Visitor
8 years ago
Solved

Help with IF OR

Hi there,

 

I am having difficulties with this formula 

Is Store Closed1 =
IF(OR([Close Date Measure1]=0||(LASTDATE(Week[Date])>[Close Date Measure1]),1,0))

 

Baiscally i am trying to show that either the store closed date is blank or that the last date of the week is bigger than the closed date, it shld show up as 1. 

 

Currently it is showing this error message Too many arguments were passed to the OR function. The maximum argument count for the function is 2

 

Could someone help me with this?? thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

     

    Try this.

     

    IF( [Close Date Measure1]=0 || LASTDATE(Week[Date])>[Close Date Measure1],1,0)

     

    Thanks

    Raj

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi HelloPowerBi

     

    Use , instead of ||.

     

    IF(OR([Close Date Measure1]=0,(LASTDATE(Week[Date])>[Close Date Measure1]),1,0))

     

    Thanks

    Raj

    • HelloPowerBi's avatar
      HelloPowerBi
      Frequent Visitor
      8 years ago

      Hi Raj,

       

      It doesnt seem to work! 

       

      Pasted this

       

      Is Store Closed1 =
      IF(OR([Close Date Measure1]=0,(LASTDATE(Week[Date])>[Close Date Measure1]),1,0))

       

      Still getting the same error message

       

      Too many arguments were passed to the OR function. The maximum argument count for the function is 2

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi

         

        Try this.

         

        IF( [Close Date Measure1]=0 || LASTDATE(Week[Date])>[Close Date Measure1],1,0)

         

        Thanks

        Raj