Forum Discussion
3 columns calculation.
Hello All,
Can someone advise how to accomplish this using power query? budget is set, committed and spent amounts are dynamic. we could commit/spend less or more. I would like the cost column to reflect properly.
Thank you!
| budget | commited | spent | cost |
| $100.00 | $ 50.00 | $ 40.00 | $ 60.00 |
| $100.00 | $ 50.00 | $ 60.00 | $ 40.00 |
| $100.00 | $ 60.00 | $ 70.00 | $ 30.00 |
| $100.00 | $ 100.00 | $100.00 | $ - 0 |
2 Replies
Hi SalimHoud ,
Refering to your data, we can get the cost column by
= [budget] - [spent]
Then what is your excepted reuslt?
I would like to also get the cost amount even if either of the committed or spent columns are blank. I have mitigated this temporary by copying the data over until spent amount is changed at the end of the month to recalculate.
