Excel Unplugged

Tag Archives: M

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. ...

Modifying Power Query M code with VBA
  • January 23, 2018

    The core of this blog post is a VBA code that will create a copy of a Power Query M code, modify it, create a new sheet and load the result of the modified Query to ...

    Get a random subset of data with Power Query

    The other day I made a Dashboard with a classic by time and relevant dimensions analysis. The data was pulled from Azure SQL DB, so Power Query was the method I ...