IF with Calculation

[AllanBerces]

Hi good day, can someone help me on my PQ, I have a table and i need some calculation 

- IF the progress value is greater than Estimated, then calculate the actual Progress else Progress

RESULT

1.68*94.05/100 = 1.58

thank you

[Deku · Accepted solution]

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

[v-hjannapu · Accepted solution]

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

[AllanBerces]

Hi @Deku @v-hjannapu thank you very much for the reply, work perfectly.

[Deku · Accepted solution]

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