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

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!