Replace values based on another column in Power Query using the Add Column Shuffle method. Apply M code and conditional logic ...
Hosted on MSN
How to use conditional columns in Excel Power Query
Excel formulas are great until you need to stack 10 of them inside each other—one wrong bracket can ruin your entire afternoon. You can skip the headache by moving that logic into Power Query.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results