by Gil Raviv | Dec 23, 2016 | Unpivot - The definitive guide
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 the Unpivot function will work well. Keep reading if you are using old versions (e.g. in Excel 2016). In...
by Gil Raviv | Nov 16, 2016 | Uncategorized
Following my last post here, Imke Feldmann, author of THE BICCOUNTANT, proposed a refined version for the solution. While my original solution is simpler for users who are reluctant of manipulating Power Query (M) expressions, Imke’s solution is simpler for...
by Gil Raviv | Oct 16, 2016 | Facebook Insights, Power BI, Power Query, Sentiment Analysis
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 the most intriguing questions of this unprecedented race. According to CNN (here) we should...
by Gil Raviv | Jun 19, 2016
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 do magic in your data, avoid repetitive manual work and save you time and money? The tool is called Power...
by Gil Raviv | Jun 7, 2016 | Popular
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 relative to the previous ones I shared. Excel is probably not the best tool for big matrices, and you may still need...
