The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
157 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
153 | |
137 | |
131 | |
81 | |
61 |