I have rows that have the name as:
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.
Go to Solution.
SEARCH ( "_m_", 'Table'[Name], 1, 0 ),
SEARCH ( "_d_", 'Table'[Name], 1, 0 ),
IF ( SEARCH ( "_t_", 'Table'[Name], 1, 0 ), "tablet", "hybrid" )
Regards,VivekIf it helps, please mark it as a solutionKudos would be a cherry on the top 🙂https://www.vivran.in/
View solution in original post
Thanks @vivran22 bro it works.
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
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!