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