Need help on Calculation

[nazrinf]

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.

[nazrinf]

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.

[v-xiaotang]

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.