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
YalanWu_test's avatar
YalanWu_test
Icon for Helper I rankHelper I
4 years ago

Hi, AKARSEVGI ;

If a dax.

column =
IF (
    (
        (
            CONTAINSSTRING ( [PROJE NO], ".S." ) || CONTAINSSTRING ( [PROJE NO], ".s." )
                || CONTAINSSTRING ( [PROJE NO], "." )
                || [PROJE NO] = BLANK ()
        )
            && [SERVİS TANIM] = BLANK ()
            && [SERVİS TİPİ] = BLANK ()
    ),
    [COUNTRY] & "é" & "900",
    [COUNTRY] & "é" & [SALDEPT]
)

If in power query.

=if  (Text.Contains([PROJE NO],".s.") || Text.Contains([PROJE NO],".S.")  || Text.Contains([PROJE NO],".")  
|| [PROJE NO] = null )
&& [SERVİS TANIM] = null
&& [SERVİS TİPİ] = null 
 then  [COUNTRY] & "é" & "900" 
 else [COUNTRY] & "é" & [SALDEPT]

Best Regards,