Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
For one of my security requirement. I will have following table as input and thinking of following table as output but dont think that is the optimized way of doing it. For lesser number of records it looks fine but when the volume of the record is too high this will not workout.
If you have any sample application which does the same. Please share the same...
Please let me know the optimised way of implementing this.
Input:
Output:
Solved! Go to Solution.
Hi @pbiforum123
Please see follow the steps in the video.
As mentioned in my post descripiton for small level of dataset it is fine but when the volume is huge then this is not the right approach. I just shared the output table for your reference.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |