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
marcelsmaglhaes's avatar
marcelsmaglhaes
Icon for Super User rankSuper User
4 years ago

Hey AKARSEVGI !

 

You can use the 'not Text.Contains' to check the values.  Create a new column to recieve checked value.

The basis is: 
Table.AddColumn(#"Added Conditional Column", "Custom", each if not Text.Contains([Status], "S.") then "Country" else if not Text.Contains([Status], "s.") then "Country" else "Another information")

 

** If this post helps, please consider accept as solution to help other members find it more quickly.

Regards
Marcel Magalhaes