Tag Archives: Merge Query

Power Query Challenge – Joining two tables fully

Posted on March 8, 2020 by MF

Left Outer + Right Anti = A better Full Join A sample file is available below. If you prefer reading to watching, please continue to read this post. The situation: I have two tables.  One is Sales Table; One is … Continue reading →

Rate this:

Posted in Power Query | Tagged , | 6 Comments

#Excel Power Query solves a real life problem – Who eats what?

Posted on January 18, 2020 by MF

Interesting application of Power Query for real life problem – See how to transform table into different layout using Power Query I came across this Power Query Challenge from Computergaga and I found it really interesting as it seems that … Continue reading →

Rate this:

Posted in Power Query | Tagged , , , , , | 7 Comments

#PowerQuery makes advanced VLOOKUP so easy!

Posted on June 21, 2018 by MF

Do you use VLOOKUP?  If you do, you should know there are limitations to VLOOKUP.  Also, there are some cases VLOOKUP is not straightforward and efficient. Consider the following cases: What we want to achieve is to map the corresponding … Continue reading →

Rate this:

Posted in Power Query | Tagged , | 1 Comment

Maintain a price book in #Excel with #PowerQuery

Posted on May 31, 2018 by MF

Feel the Power (Query) This is my first post devoting to my recent love for Excel – Power Query.  🙂 First, let me make myself clear.  I am still learning Power Query (indeed I am still learning Excel too).  The … Continue reading →

Rate this:

Posted in Power Query | Tagged , , | 4 Comments