Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm trying to get running percentages for this dummy dataset based on a real dataset:
MemberID, PortfolioID
1,1
1,2
1,3
1,4
1,5
1,6
1,7
1,8
1,9
1,10
2,1
2,2
2,3
I want to add another column [Running Percentages] to this dataset as below:
MemberID, PortfolioID, RunningPercentage
1,1, 10%
1,2, 20%
1,3, 30%
1,4, 40%
1,5, 50%
1,6, 60%
1,7, 70%
1,8, 80%
1,9, 90%
1,10, 100%
2,1, 33%
2,2, 66%
2,3, 100%
In SQL, there is the percentile_rank, but how do I do this in Power BI?
Thank you!
Solved! Go to Solution.
Proud to be a Super User!
Proud to be a Super User!
It works perfectly. Thank you!
User | Count |
---|---|
106 | |
86 | |
81 | |
72 | |
71 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |