Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hi
Try this.
IF( [Close Date Measure1]=0 || LASTDATE(Week[Date])>[Close Date Measure1],1,0)
Thanks
Raj
Use , instead of ||.
IF(OR([Close Date Measure1]=0,(LASTDATE(Week[Date])>[Close Date Measure1]),1,0))
Thanks
Raj
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
Hi
Try this.
IF( [Close Date Measure1]=0 || LASTDATE(Week[Date])>[Close Date Measure1],1,0)
Thanks
Raj
works thanks raj!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |