Forum Discussion

bbotros77's avatar
bbotros77
Frequent Visitor
3 years ago

"If Formula

Hi There , 

I am looking to use "If"  formula to let Power BI apply a certain rule only if the "Service Date" has date (not blank) .

how to type this formula please. Appreciate any help

 

 

Need Help

2 Replies

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    3 years ago

    IF([Service Date] <> "", [something], [else something else])
    OR 
    IF(NOT(ISBLANK([Service Date])), [something], [else something else])

    • bbotros77's avatar
      bbotros77
      Frequent Visitor
      3 years ago

      Thank you Vicky. I also put  IF (service Date) >0 and it works , my assumption was this will let Power BI pick any cell that has value.