Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team
I have below global volumes and the region wise Volume share which is in %.
Please can you help me with the formula for volume disturbution based on % split mentioned ?
Hi @shantupm5
If I understand you correctly you can add in PQ column for every category with multiplying it on percentage :
after you will add all necessary splittings, you can delete columns that you don't need:
Result:
These steps are recorded and will complete on every refresh.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |