Bulk Find And Replace In Power Query
Learn how to do a bulk find and replace in power query based on a list of values.
Read Moreby John | Jan 28, 2019 | Get & Transform, Power Query | 16 |
Learn how to do a bulk find and replace in power query based on a list of values.
Read Moreby John | Jan 17, 2019 | Get & Transform, Power Query | 4 |
Learn how to build a custom query function in power query that will replicate Excel’s TRIM function.
Read Moreby John | Dec 23, 2018 | Get & Transform, Power Query | 17 |
Learn the basics of power query’s M code language with this complete guide to M code.
Read Moreby John | Jul 15, 2018 | Get & Transform, Power Query | 7 |
In this post we’ll take a look at how to import an XML file into Excel and turn it into a more human readable table format. Excel has support for XML files and it’s actually really easy to import and covert them to tables using Power Query
Read Moreby John | Jun 11, 2018 | Get & Transform, Power Query, Tips & Tricks | 18 |
Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.
Read Moreby John | May 26, 2018 | Get & Transform, Power Query | 0 |
Learn how to add grouped serial numbers to your data using Power Query.
Read Moreby John | May 6, 2018 | Get & Transform, Power Query | 0 |
This post will show you how to import the metadata from a CSV file into our report data with power query (also called Get & Transform).
Read Moreby John | Apr 28, 2018 | Get & Transform, Power Query | 6 |
Use power query to transform a single column into a table.
Read More