Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a requirement as per screenshot below. It comes from one table with many columns.
Scope Impact Column {S1 reduction, S2 reduction}
MAAC Column {have positive and negative value}
IREC Availability Column {have postivie and negative value}
Payback Column {numeric value}
Can someone help me with the calculation? Should I created a calculated column in power query? I don't have the column for Points.
Thank you.
Hi,
Apologise, I could not upload the sample data due to restriction of company policies. Herewith is the some of sample data for reference.
PROJECT_ID | SCOPE_IMPACT | MAC | IREC | PAYBACK |
Project 1 | Scope 1 | -44 | 3 | |
Project 2 | Scope 2 | 0.466667 | 3 | 6 |
Project 3 | Scope 2 | -102 | 2 | |
Project 4 | 0 | 4 | ||
Project 5 | Scope 2 | 0.466667 | 3 | 6 |
Project 6 | Scope 2 | 0 | 0 | 0 |
Project 7 | Scope 2 | -28 | 4 | |
Project 8 | Scope 2 | -161 | 2 | |
Project 9 | Scope 1 | -16 | 3 | |
Project 10 | Scope 2 | -86 | 1 | |
Project 11 | Scope 2 | -88 | 4 | |
Project 12 | Scope 2 | -88 | 5 | |
Project 13 | Scope 2 | -54 | 3 | |
Project 14 | Scope 2 | -287 | 5 | |
Project 15 | 0 | 5 | ||
Project 16 | Scope 2 | -237 | 2 | |
Project 17 | Scope 1 | 0.133333 | -20 | 13 |
Project 18 | Scope 1 | 0.1 | 2 | 2 |
Project 19 | Scope 2 | 0.2 | -4 | 4 |
Project 20 | Scope 1 | 0 | -12 | -16 |
The result would see the point by project ID.
Thanks.
Hi @nazrinf
Thanks for reaching out to us.
could you share some sample data? thanks
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.