Forum Discussion
Solved
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-->...
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