Don't have Telegram yet? Try it now!
https://www.biinsight.com/quick-tips-conditionally-replace-values-based-on-other-values-in-power-query/
Quick Tips: Conditionally Replace Values Based on Other Values in Power Query