Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
How can I get the result of Table 2, if I have Table 1?
Names with "+" sum into one corresponding name.
For example:
Solved! Go to Solution.
i dont know how to do it in dax but in power query
go to transform
press on the Name column choose split by delmiter
now the delimiter is custom and "+"
and press advanced and choose by row
result
now group your name by sum of sum
final result
i dont know how to do it in dax but in power query
go to transform
press on the Name column choose split by delmiter
now the delimiter is custom and "+"
and press advanced and choose by row
result
now group your name by sum of sum
final result
Thank you!!!
User | Count |
---|---|
94 | |
87 | |
79 | |
76 | |
69 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |