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...
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.
