In this blog post, we provide a detailed tutorial to dynamically replace multiple column values in one step in Power Query using some simple M programming. This data transformation step is applicable in Microsoft Power BI and Excel.