Tag Archives: Excel
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 [...]
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 [...]
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: Resouce planning report with selecting a date parameter
I had an interesting question on my ask a questions page, one that I have (or something similar) heard a few times before. So I decided to do make a blog post on how to solve it Our company tracks changes in the resource planning using a data warehouse. An example would be: Assignment 1: [...]
Crushed by Your Calendar? Use PowerPivot to analyze why !
Today the Microsoft’s Business Intelligence team released a very cool PowerPivot app that shows you the power of PowerPivot from a direction you wouldn’t expect: REDMOND, Wash. — April 27, 2011 — As tools, email and calendars go one of two ways for many people. “Your calendar can be on top of you, or you can be [...]
Use PowerPivot DAX to get values within a Start and End date
Again a interesting question on my ask a questions page, keep them coming :) Luke had a question where he wanted to get a date based calculation: I have a table of people and a table of project assignments. The assignments have a person, start date, end date and number of hours per week. I want to [...]
Use PowerPivot DAX and Excel to create a sparkline with running total last 12 month
Got an interesting question today. The question was about creating sparklines for all the country’s that shows a running total of sales for the last 12 months (Rolling 12 months) based on the year that I select from a slicer. I use the trick I blogged about before to work with sparklines and PowerPivot, I would recommend reading [...]
The Office Show: Attack budgeting with Excel PivotTables
Check out this great video from the Office team on what Excel and PowerPivot can do for you and your organisation: The Office Show is in a budget crisis, and the numbers are a mess. Watch how we use Excel PivotTables and the super-powerful PowerPivot add-in to pull in all the data and discover some, [...]
Login