Tag Archives: Group By

Split date ranges from cells with #Excel #PowerQuery

Take a look at the challenge presented above.  Is it possible to do it in Excel? Be honest, without Power Query, I have no idea how to do it but manual work. 😁🤦‍♂️ Believe it or not, with Power Query, … Continue reading

Rate this:

Posted in Power Query | Tagged , , , | Leave a comment

Power Query Challenge – Joining two tables fully (Part 2)

Append Queries + Group By = Another alternative for a better Full Join In the previous post, we explored an alternative way to perform FULL OUTER JOIN with Left Outer Join + Right Anti Join, followed by Append Queries in … Continue reading

Rate this:

Posted in Power Query | Tagged , | 1 Comment