Conditional column is not automatically updated

[lastnn30]

Hi

In power query, I added conditional column with the following codition

if score >= 50 , pass

if score < 50, fail

It worked fine but then, in Power Query, I selected Score column-->Transform--> Standard-->Add

So I added 10 to all cells in column Score. I had Lexi scored 44 so she got Fail but then added 10, her score became 55 but

she still has FAIL ! Any idea please how to update the conditional column? Thank you very much.

[HotChilli]

This is all to do with the order of steps (on the right hand side of the screen).

Adding 10 as the last step doesn't affect earlier steps (for example, the assignment of pass/fail.)

I'm not exactly sure why you're doing this but assigning pass/fail at the end would work

[jdbuchanan71 · Accepted solution]

Did you put the add step after the conditional column (pass / fail) step?  If so, the change would not get picked up by the logic for the pass/fail step since that had already been evaluated.