| Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot |
| Written by Kasper de Jonge |
| Friday, 18 June 2010 21:38 |
|
Today I did a PoC using PowerPivot, both to show Self Service BI with PowerPivot for SharePoint but also as a datasource for SSRS reports. I used DAX to solve all difficult request, mostly making use of the Time Intelligence functions. One of the requests was if we could show a running sum of the last 6 months. I had not done that before, so today we take a look at how to do this with DAX. It appeared to be rather easy
|
Author articles
- Project: Gain insight into your music taste using Last.fm, PowerPivot and the PivotViewer
- Predict the future using Predixion data mining and PowerPivot
- Datamining using PowerPivot and Predixion Insight
- Determine the min value over rows in a group using MINX in PowerPivot
- Importing data from SSAS into PowerPivot when you have different regional settings
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
