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...
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

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

  • HelloPowerBi's avatar
    HelloPowerBi
    Frequent Visitor
    8 years ago

    works thanks raj!