Earn 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |