3 columns calculation.

[SalimHoud]

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

[v-frfei-msft]

Hi @SalimHoud ,

Refering to your data, we can get the cost column by

= [budget] - [spent]

Then what is your excepted reuslt?

[SalimHoud]

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.