Tag Archives: PowerPivot
PowerPivot Use Case: Getting the active products between a date range using DAX
I have been getting this question a few times in the last week, e.g. in my ask a questions page here, on how we can get the number of active products between two time intervals in Excel. Lets answer the question on my ask a questions page in todays blog post. The question was: DESIRED [...]
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 [...]
Online session: Enriching your BI Semantic Models with Data Analysis Expressions (DAX)
As part of the SQL Server 2012 release Microsoft has released sessions on the Microsoft Virtual Academy one of the is sessions is 7 Module session on Breakthrough Insights using Microsoft SQL Server 2012 – Analysis One of the session there is one I did together with my colleague Howie Dickerman called: Enriching your BI Semantic Models with Data Analysis Expressions. [...]
Tutorial: Optimize a Sample PowerPivot Model for Power View Reports
Our documentation team released a great tutorial that explains all the ins and outs on what you need to do when you want to optimize your tabular model for Power View The entire tutorial can be found here: http://social.technet.microsoft.com/wiki/contents/articles/6176.aspx
How to unpivot using Excel and load it into PowerPivot
I had an interesting question today where someone send me a workbook that contained a flattened table like this: Now as a result we want to see the top 1 nr of products per country. The problem here is that we cannot just load this data into PowerPivot and start analyzing to get this result. In [...]
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