Forum Discussion
Need Help
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
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
1 Reply
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