Custom column filter with user values

[jibran]

Hi,

I am struggling to write a simple dax where I want to create a calculated column on the basis of database column

like I have a table 

ID      Product                Calculated Column

1        Iphone 3              iphone

2        Iphone 4              iphone

3        Samsung s6         android

4        Samsung s5         android

I want to create dax query in calculated column whereever there is iphone3, iphone4 calculated column shows iphone and where there is samsung s6 and samsung s5 it shows android

Many Thanks 

Jibran Ishtiaq

[v-haibl-msft · Accepted solution]

@jibran

Please try with following DAX expression.

Calculated Column = 
IF (
    SEARCH ( "Iphone", Table1[Product],, 0 ) > 0,
    "iphone",
    IF ( SEARCH ( "Samsung", Table1[Product],, 0 ) > 0, "android" )
)

Best Regards,

Herbert