Need to search specific letter and assign that Name

[arvindyadav]

Hi Team,

I have rows that have the name as:

arvind_m_vimal

ashish_d_chopra

harsh_t_paleja

and I need to assign it as if _m_ appears it reflects as Mobile, if _d_ appears it reflects as  desktop and if _t_ appears then reflects as tablet otherwise hybrid.

Thanks,

Arvind

[vivran22 · Accepted solution]

@arvindyadav 

Try this:

Column =
IF (
    SEARCH ( "_m_", 'Table'[Name], 1, 0 ),
    "Mobile",
    IF (
        SEARCH ( "_d_", 'Table'[Name], 1, 0 ),
        "Desktop",
        IF ( SEARCH ( "_t_", 'Table'[Name], 1, 0 ), "tablet", "hybrid" )
    )
)

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/

[arvindyadav]

Thanks @vivran22  bro it works.

[amitchandak]

Try Like

Switch(true(),
search("_m",table[Name],1,0)>0 ,"Mobile",
search("_d",table[Name],1,0)>0 ,"Desktop",
"Hybrid"
)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin