Forum Discussion
Solved
Count Word which split with (;) in Row
Hello,
I have this,
| Labor |
| Ara |
| Ara;Kiano |
| Ara |
| Kiano |
| Kiano;Edi Wan;Fahri Hamid |
I want to get this column in Power BI:
| Labor | Count |
| Ara | 1 |
| Ara;Kiano | 2 |
| Ara | 1 |
| Kiano | 1 |
| Kiano;Edi Wan;Fahri Hamid | 3 |
How to do it? Thank you
pls try in DAX
