biinsight.com
Quick Tips: Conditionally Replace Values Based on Other Values in Power Query
In this post you learn how to conditionally replace values in Power Query (M) instead of adding unnecessary calculated columns.