Articles By Kasper de Jonge

ArticleDate Published
Use PowerPivot DAX to automatically report on the last month that has data2010-Jul-21
Using the excel function SEARCH in PowerPivot DAX2010-Jul-08
Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible2010-Jul-07
What is that PowerPivot pivottable context they keep talking about?2010-Jun-21
Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot2010-Jun-18
Load data from SAP into PowerPivot for Excel2010-Jun-17
Ok why should i want to load an entire time table in PowerPivot ?2010-Jun-15
Doing a simple forecast with PowerPivot Time intel functions2010-Jun-15
PowerPivot time intelligent functions: why use ALL() and how to work around it2010-Jun-04
Use slicer values in a calculation with PowerPivot DAX2010-Jun-03
Calling a Stored procedure in PowerPivot to populate your date table2010-Jun-01
Where to create PowerPivot calculations and why2010-Jun-01
Where to create PowerPivot calculations and why2010-May-27
Get insight to SharePoint PowerPivot usage without Central admin rights using custom SSRS reports2010-May-17
Using a PowerPivot workbook from SharePoint with a too long url in PowerPivot2010-May-09
Get the value of a measure of the last x intervals from the current datetime with PowerPivot2010-May-08
PowerPivot Data Refresh, what settings to use and why2010-May-06
Review new PowerPivot workbooks on SharePoint using approval workflows2010-May-03
Building a cash flow statement in PowerPivot using dynamic measures in DAX2010-Apr-27
PowerPivot Time intelligent function and other DAX example2010-Apr-21
Create IPhone BI using RoamBI and data from PowerPivot2010-Apr-18
Creating a measure in PowerPivot that excludes values that are in a second table (like SQL Not in)2010-Apr-16
Create a separate related time table for time intelligent functions in PowerPivot2010-Apr-15
Combine two files (or fact tables) in PowerPivot using relationships, relationships explained2010-Apr-11
PowerPivot and Sparklines .. the easy way2010-Apr-01
PowerPivot time intelligent functions revisited: why use ALL() and how to work around it2010-Mar-29
PowerPivot and Sparklines .. the easy way2010-Mar-19
Add a new Pivottable or Pivotchart and reuse the slicers of an existing PowerPivot workbook2010-Mar-19
Make your PowerPivot on SharePoint “view onlyâ€2010-Mar-04
Screencast: Using datamining with PowerPivot in Excel2010-Feb-23
Screencast: Using datamining with PowerPivot in Excel2010-Feb-13
Using Time intelligent PowerPivot functions with fiscal year2010-Feb-09
Troubleshooting PowerPivot Relationships2010-Feb-08
Screencast: Import data from reporting services into PowerPivot2010-Jan-19
Enable PerformancePoint on SharePoint 20102010-Jan-15
Screencast: Introduction to time intelligent functions in PowerPivot2010-Jan-13
So i requested a PowerPivot workbook from SharePoint, what happens?2010-Jan-10
Manage the sort order of your PowerPivot sheets in the SharePoint Gallery2010-Jan-10
Creating a PerformancePoint 2010 dashboard on a published SharePoint PowerPivot app2010-Jan-04
Creating a SSRS report on a published SharePoint PowerPivot app2009-Dec-31
Solving a business problem with Powerpivot CTP3 using DAX Timefunctions2009-Dec-31
Monitor your SSIS Package execution with PowerPivot2009-Dec-17
Getting difference of two dates in seconds with PowerPivot DAX2009-Dec-05
Calling your PowerPivot workbook on SharePoint 2010 remotely2009-Dec-02
Make your PowerPivot sheet look great in SharePoint 20102009-Dec-01
Combine data from the cloud with local data using PowerPivot and Dallas2009-Nov-25
Using PowerPivot to combine cube (SSAS) data with manual data, the movie2009-Nov-24
Using PowerPivot to combine cube (SSAS) data with manual data2009-Nov-23
Trying to solve a business problem with Powerpivot, Gemini CTP22009-Oct-26
Working with Gemini (PowerPivot) and Excel 2010 to make a pivot table2009-Aug-17