Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

IF with Calculation

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 RESU...
Need Help
  • Deku's avatar
    Deku
    1 year ago

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

  • v-hjannapu's avatar
    v-hjannapu
    1 year ago

    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

v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

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's avatar
    AllanBerces
    Post Prodigy
    1 year ago

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