M Language - Excelerator BI

M Language

Import First Sheet with Power Query

Import the First Sheet in a Workbook with Power Query

My series about common patterns for loading data using Power Query received quite a lot of interest over the last few weeks.  You can review those articles in the links below Combine all files in …

Import the First Sheet in a Workbook with Power Query Read More

Combine All Sheets in a Workbook with Power Query

There are quite a few different common business scenarios where you get data in the form of a file on a regular basis.  The 3 common patterns I use most often are. Each day/month/year you …

Combine All Sheets in a Workbook with Power Query Read More

Best Book for Learning the M Language

Late in 2018 there was a new Power Query book written by Gil Raviv called Collect, Combine and Transform Data Using Power Query in Excel and Power BI.  That’s a bit of a mouthful actually; …

Best Book for Learning the M Language Read More

Scroll to Top