With Power Query, you can add a conditional column to your query by defining IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column automatically displays the ...

With Power Query, you can create new columns whose values are based on one or more conditions applied to other columns in your table. The **Conditional column** command is located on the **Add column* ...

Also, select Number instead of Percent for the number format. In my example below, I have a table that has got Bike Brands and Types. Check out our courses in RADACAD Academy for all aspects of Power ...

Simon Hurst looks at conditional columns and the Power Query equivalent of the well-known IF() function. IF() is one of the most frequently used Excel functions. The ...

Picture this: yet another Excel report lands in my inbox, and, once again, it's a nightmare of leading spaces, inconsistent spelling, and useless rows. Previously, I would spend hours fixing it ...