Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |