Unpivot Bug in Power Query
May 2017 Update: This article describes a bug that is already fixed in Power BI Desktop, May update. You can now use the Unpivot Only Selected Columns, and...
Tag: Get & Transform
Improve refresh time by batching Web API calls – Part 2
Following my last post here, Imke Feldmann, author of THE BICCOUNTANT, proposed a refined version for the solution. While my original solution is simpler...
Clinton vs Trump – Whose campaign is more negative? Opponent-Mentions and Sentiment Analysis in Excel
Are You Ready for the Debate? Today is the US Presidential debate. It is also a perfect opportunity to hone our analytical skills and answer some of...
What is Power Query?
So what is Power Query? You do work with Excel, or Power BI, right? Did you know that there is an amazing new feature in Excel and Power BI that allows you to...
Faster Matrix Mulitplication
As a followup for our recent Matrix Multiplication post here, I would like to share with you a faster query for Matrix Multiplication (Faster only...
Power Query List.Accumulate – Unleashed
Following a reader's request, today we will unleash the power of List.Accumulate. The official documentation on List.Accumulate here was very confusing for...
Split and Unpivot Comma-Separated Values
By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (all posts here), you will feel confident with the following...
Transform ANY nested table to Pivot Table with function query
Get ready to be amazed :) This is the fourth post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you...
Transform a nested table to PivotTable
This is the third post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data...
Back to School – Transform class schedule to PivotTable
Back to school with Excel & Power Query This is the second post in the series The Definitive Guide to Unpivot with Power Query in Excel. For today's post...
