Power Platform Integrations (Read-only)
Power Platform and Dynamics 365 Integrations (Read-only)
Training and Consulting
Instructor Led Training
Dashboard in a Day for Women, by Women
Galleries
Community Connections & How-To Videos
COVID-19 Data Stories Gallery
Themes Gallery
Data Stories Gallery
R Script Showcase
Webinars and Video Gallery
Quick Measures Gallery
2021 MSBizAppsSummit Gallery
2020 MSBizAppsSummit Gallery
2019 MSBizAppsSummit Gallery
Events
Ideas
Custom Visuals Ideas
Issues
Issues
Events
Upcoming Events
Community Blog
Power BI Community Blog
Custom Visuals Community Blog
Community Support
Community Accounts & Registration
Using the Community
Community Feedback
Hello everybody, how are you?
I need your help urgently for a problem I'm having.
I have a column with different values, but with a specific string that repeats in more than one row.
What do I need to do?
I need to categorize these specific strings into 3 different categories, which are the regions that each location equals.
I am trying to use SWITCH with CONTAINSSTRING, because I need it to return the text I want in the calculated column if it finds the text I am looking for.
But it is not working. Can anyone help me and tell me where I am going wrong, or any alternative way for me to get what I want?
TRUE(),
CONTAINSSTRING('Table'[Anuncio],"Taubate")=TRUE(),"Taubate",
CONTAINSSTRING('Table'[Anuncio],"Canas")=TRUE(),"Canas")
2. Result:
Best Regards,
Liu Yang
If this post
helps
, then please consider
Accept it as the solution
to help the other members find it more quickly
TRUE(),
CONTAINSSTRING('Table'[Anuncio],"Taubate")=TRUE(),"Taubate",
CONTAINSSTRING('Table'[Anuncio],"Canas")=TRUE(),"Canas")
2. Result:
Best Regards,
Liu Yang
If this post
helps
, then please consider
Accept it as the solution
to help the other members find it more quickly
@matheus_peppers
, You should use Switch (True(),
and then you can check for true in each expression
Switch-Case statement of #PowerBI:
https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.