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.
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.