2 lines of code can save you from having to refer directly to columns and therefore make you refresh more robust in the future.
Whether it's replacing nulls with zeros or any other replacement this technique can help
I refer to a blog article by Gil Raviv around avoiding directly referencing columns when detecting data types: datachant.com/2018/05/14/automatic-detection-of-column-types-in-powerquery/
Content
00:00 Intro
00:19 The Scenario
01:00 How we do it
03:25 Table.ColumnNames
03:40 Editing Table.ReplaceValues
04:51 Subscribe
Follow me on LinkedIn
linkedin.com/in/wynhopkins/
Twitter
twitter.com/wynhopkins
Access Analytic Blog
accessanalytic.com.au/blog
- Power Query Replace Values the safer way ( Download)
- Replace Values Based on Condition (in a Single Step) in Power Query ( Download)
- Replace multiple values in Power Query in one step ( Download)
- 34. Find And Replace Values | Power Query Editor ( Download)
- Power Query: How to mass replace values based on a list | Excel Off The Grid ( Download)
- Perform a Case Insensitive Replace Values in Power Query ( Download)
- Power Query - Bulk Replace Values in One Step 🔄📊 ( Download)
- How do you replace certain values in Power Query | Find and Replace ( Download)
- Finding and Replacing Column Values in Power Query ( Download)
- Power Query Tutorial: How to Conditionally Replace Values Without Creating New Columns ( Download)
- Replace Multiple Column Values in One Step [Power Query Tips & Tricks] ( Download)
- Bulk Replacements (Replace Multiple Values in a Table at once) in Power Query ( Download)
- 29 - Replace the values in a column on a condition (Power Query) ( Download)
- REPLACE VALUES Power Query Power BI QUICK and EASY in 1 Minute ( Download)
- Power Query - Replace Value not working ( Download)
