Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
pls try in DAX
pls try this
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |