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

RESULT

1.68*94.05/100 = 1.58

thank you

 

 

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

3 Replies

  • Deku's avatar
    Deku
    Super User
    1 year ago

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

  • 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