Implementing histograms in Excel 2013 using DAX query tables and PowerPivot | Kasper de Jonge Microsoft BI Blog
I got a great question last month on how to implement a histogram in PowerPivot, similar to this great blog post by Tomislav Piasevoli for Multi Dimensional. I decided to solve the problem in Excel…
Power Pivot / Power Query Read-Only Connection Problems In Excel 2013 – And What To Do About Them – Chris Webb's BI Blog
Anyone who has tried to do any serious work with Power Pivot and Power Query will know about this problem: you use Power Query to load some tables into the Data Model in Excel 2013; you make some c…
Sort Your Data on Load for Improved Compression - PowerPivotPro
My last 2 blog posts have been about data compression – that theme continues today. In December I blogged about the basics of compression and impacts that
New Ways To Concatenate Text In Excel 2016 With CONCAT() And TEXTJOIN() – Chris Webb's BI Blog
I don’t normally blog about Excel topics outside of Power Query and Power Pivot, but I think anyone who has ever done any serious work in Excel has found how difficult it is to concatenate more tha…
Removing offset duplicates using Power QueryThe Ken Puls (Excelguru) Blog
This post solves a tricky issue of removing offset duplicates or, in other words, removing items from a list that exist not only in a different column, but also on different rows. Problem History This data format is based on … Continue reading →
Using Excel Power Query to Unpivot and Transform Data for SPSS Analysis of Variance
Excel, of course, is quite capable of providing simple statistical summaries and analyses. However, there are occasions when bigger guns must be brought to bear on a statistical problem, and Excel