Forum Discussion

AKARSEVGI's avatar
AKARSEVGI
Icon for Helper I rankHelper I
4 years ago

POWER QUERY IF

How can I rewrite this ------- IF(( ("PROJE NO" LIKE '%.S.%' OR "PROJE NO" LIKE '%.s.%' OR "PROJE NO" NOT LIKE '%.%' OR "PROJE NO" IS NULL ) AND "SERVİS TANIM" IS NULL AND "SERVİS TİPİ" IS NULL) THE...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Power Query uses small letters

 

IF => if

IS NULL => = null

AND => and

 

etc.

 

Power Query does not have a concept of "LIKE" - you need to write that manually.