Category: Get & Transform
Amazing Power Query Tips and Tricks
Power query is awesome! Here are some tips and tricks to help you get the most out of this amazing data transformation tool.
Read More
Create Grouped Serial Numbers with Power Query
Learn how to add grouped serial numbers to your data using Power Query.
Read More
Adding Metadata to a Report with Power Query
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 More
Transform a Column to a Table with Power Query
Use power query to transform a single column into a table.
Read More
How To Get All Sheet Names From All Workbooks In A Folder
It’s a task I’ve had to do before. Get a list of all the sheet names in a workbook...
Read More
How to Deal with Changing Data Formats in Power Query
Power Query is an amazing tool since it allows you to set up a query once and then refresh it...
Read More
