Need Help

[aotero1]

Hello, 

I hope someone can help with this issue I am having. I am trying to look at a list of assets with multiple attribute columns and create a calulated column that is based on an editable field in the same table.  

Here is a quick table to better illustrate what I am trying to do. The calculated column would be the New Fiscal Year of Replacement column and the editable field would be the Delay column:

Asset	User	Fiscal Year of Replacement	New Fiscal Year of Replacement	Delay
A	1	2010	"=Fiscal Year + Delay"	0
B	2	###	"=Fiscal Year + Delay"	1
C	3	###	"=Fiscal Year + Delay"	2
D	4	###	"=Fiscal Year + Delay"	2
E	5	###	"=Fiscal Year + Delay"	2

Thanks

[Anonymous · Accepted solution]

@aotero1,

Based on my test, we can use the formula as below to get the result what we need. Here both the Fiscal Year of Replacement and Delay should be in Number format.

New Fiscal Year of Replacement = Table1[Fiscal Year of Replacement] +Table1[Delay]New Fiscal Year of Replacement = Table1[Fiscal Year of Replacement] +Table1[Delay]

For more information, please refer to the pbix as attached.

Regards,
Lydia