IF with Calculation

Table.addcolumn( previousStep, "Result", each if [progress] > [estimated] then [estimated] * [% complete] / 100 else [progress])

Hi AllanBerces,

Thank you  for reaching out to the Microsoft fabric community forum.
Thank you Deku, for reply regarding the issue.

By using this formula you may create custom column:

if [Progress] > [Estimated] then [Estimated] * [PercentComplete] / 100 else [Progress]

Please find the attched Pbix file and screenshot for your reference

If your issue is sorted out, don’t forget to Accept it as the solution and give it a Kudos  it helps other members find helpful answers faster.

Best Regards,
Harshitha.
Community Support Team