Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Experts
I need to calculate how many Projects of each company moved from Phase 1 to Phase 3 as a Percentage. See sample dats below
in the explain below for company ABC Phase 1 = 17 Projects and Phase 2 = 8 Projects hence 47 of the applications moved to the second phase ie. Phase 2 , then 2 out of 8 projects move to final phase 3 = 25%.
Co Name | Phase 1 | Phase 2 | Phase 3 |
ABC | 17 | 8 | 2 |
SSF | 16 | 11 | 4 |
DDCW | 11 | 9 | 5 |
Solved! Go to Solution.
Hi,
i'm unsure on the explanation are you just looking for the calculation to work out between phase 2 and 3 to give you the 25% figure:
if so
Hi,
i'm unsure on the explanation are you just looking for the calculation to work out between phase 2 and 3 to give you the 25% figure:
if so
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |