Forum Discussion
Conditional column is not automatically updated
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.
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.
2 Replies
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.
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
