How to add a new column in Power Query. ... Medium: 50, X Large: 20, Small 15. To accomplish this, we need to add a new column for the combined values as follows: ...

Power Query, otherwise known as Get & Transform, is available in earlier ribbon versions, but you need to install it as an add-in. There’s no comparable tool in earlier menu versions.