Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, I have data where I have 4 records that start with the same name, but the difference is an additional text to recognize who they belong (see figure), how can I do so that in the selection list appear grouped to treat them as a single data, is it possible?
Thank you very much for your support
Solved! Go to Solution.
Hi @Juanjoge .
You could refer to the following DAX:
Column =
VAR a =
SEARCH ( " ", 'Table'[Records], 1, 0 )
RETURN
IF ( a > 0, LEFT ( 'Table'[Records], a - 1 ), 'Table'[Records] )
Here is my test result.
Hi @Juanjoge .
You could refer to the following DAX:
Column =
VAR a =
SEARCH ( " ", 'Table'[Records], 1, 0 )
RETURN
IF ( a > 0, LEFT ( 'Table'[Records], a - 1 ), 'Table'[Records] )
Here is my test result.
@Juanjoge , refer if this can help
https://www.poweredsolutions.co/2019/03/26/fuzzy-matching-in-power-bi-power-query/
https://www.youtube.com/watch?v=I65YCrJWliw
@Juanjoge well you have to group these together, are these only 3 values you need to group
New Column=
IF (Containsstring(Table[Column], "Mining City", "Mining City",Table[Column] )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |