Excel Unplugged

Tag Archives: M Language

Extract Columns that Contain Actual Values

We often work with large datasets containing multiple columns, but only need a few. In this tutorial we’ll show how to extract the columns that contain Actual ...

Ultimate Vlookup Alternative? (Part 2)

This is part 2 of the Ultimate Vlookup Alternative post and a continuance from last week’s post. We will be using the same Excel workbook as we did in part ...

Ultimate Vlookup alternative? (Part 1)

Almost a year ago, more precisely in May of 2017 a site called defeat excel invited 27 Excel Experts (including myself) to end the endless debate of Vlookup vs. ...

Making Importing from Folder in Power Query (or Power BI) Bulletproof

I’ve always been a big fan of the Import from Folder feature in Power Query. So much so, that I wrote my first post on the topic way back in February of 2015. ...

Table.Join – The Power Tool of Power Query

The basic explanation of Table.Join function in Power Query is to use Merge Queries on two steps of one single query.This will be a step by step tutorial on how to ...