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
Solved! Go to Solution.
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/
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/
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