Help with IF OR

[HelloPowerBi]

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!

[Anonymous]

Hi @HelloPowerBi

Use , instead of ||.

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

Thanks

Raj

[HelloPowerBi]

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 · Accepted solution]

Hi

Try this.

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

Thanks

Raj

[HelloPowerBi]

works thanks raj!