Category Archives: DAX
Analyze a Twitter feed with Excel 2013, DataExplorer and GeoFlow
I recently got access to a csv file that contains twitter feeds filtered by Azure. I want to do some simple analytics on where the twitter users live in a visual way. I am going to load the csv file into Excel using DataExplorer (download add-in for Excel 2012 here). And I select Import from [...]
PowerPivot case: what product made the most sales change in the last 7 days
Ok here is an interesting case that I got asked last week. The question was we would like to know the top 10 product who made the best change over the last 7 days. I solved the problem based on adventureworks, this is the schema I used: First thing that I want to do [...]
PowerPivot case: Does a value exist in both columns ?
I had a interesting question on my ask a questions page that I wanted to answer by solving it using PowerPivot. The following question was asked: If i have a powerpivot table whith phone numbers in two different columns. Can i make some kind if a search formula if i want to search a specifik number [...]
Implementing histograms in Excel 2013 using DAX query tables and PowerPivot
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 2013, PowerPivot and DAX and show you some of the great things Excel 2013 allows us to do. First thing [...]
Using IFERROR/ISERROR in your DAX formula
Thanks to all the folks who I talked to at TechEd NA who gave me encouraging words to do more blog posts. I will try to add more blog posts in the near future. Today a small nugget / tip. Many DAX measure will use IFERROR/ISERROR in the measure to catch a divide by zero error. [...]
Learn PowerPivot DAX Basics in 30 Minutes
Are you new to data modeling in PowerPivot or SQL Server Data Tool (aka BIDS) or never had the chance to start with DAX, now is the time. We have released online content to help you get started in creating DAX formulas. You can think of this as DAX 101. The QuickStart: Learn DAX Basics [...]
PowerPivot DAX case: compare product sales by months since product introduction
A few weeks ago I got this interesting question from someone. He wants to compare the sales growth of his products in the months since the introduction of the product. Lets say “Product One” first selling date is 1/2/2010 and “Product Two’s” first selling date is 2/1/2010. If we want to compare the sales since [...]
PowerPivot DAX PARALLELPERIOD vs DATEADD
Something that might be interesting to know is that DATEADD and PARALLELPERIOD look very similar but do behave differently. This blog posts looks at the difference between the two. Lets look at these two formula’s: =CALCULATE([Sum of SalesAmount], DATEADD(DateTable[FullDateAlternateKey],-1,YEAR)) =CALCULATE([Sum of SalesAmount], PARALLELPERIOD(DateTable[FullDateAlternateKey],-1,YEAR)) They both look very similar right ? But what is the difference ? Lets look at the results: [...]
Login