Articles By Kasper de Jonge

ArticleDate Published
Help, I received a pivoted data file that I want to combine with my data in PowerPivot2013-May-03
When Importing from Tabular Model use DAX2013-Apr-25
Analyze a Twitter feed with Excel 2013, DataExplorer and GeoFlow2013-Apr-20
NBA team spending and their results with Excel, PowerPivot and Data Explorer2013-Mar-24
What is eating up my memory the PowerPivot / Excel edition2013-Mar-18
Excel 2013, Power View, top 10, "long tail" and how DAX helps2013-Jan-08
Templated Excel workbooks with PowerPivot and Macro's2012-Dec-03
Import data into the model using a Macro in Excel 20132012-Oct-04
PowerPivot case: what product made the most sales change in the last 7 days2012-Sep-24
PowerPivot case: Does a value exist in both columns ?2012-Sep-24
Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros2012-Jul-26
Video - Enriching Your BI Semantic Tabular Models with DAX2012-Jul-24
Video - Building Self-Service BI Applications Using PowerPivot2012-Jul-24
Using IFERROR/ISERROR in your DAX formula2012-Jun-18
Video - Enriching Your BI Semantic Tabular Models with DAX2012-Jun-14
PowerPivot and Excel: Using a dynamic label in a chart2012-Jan-08
PowerPivot: Calculate ratio to parent2012-Jan-08
How to unpivot using Excel and load it into PowerPivot2011-Dec-08
PowerPivot DAX PARALLELPERIOD vs DATEADD2011-Aug-16
PowerPivot DAX: Find and Search in Denali2011-Aug-16
PowerPivot DAX case: compare product sales by months since product introduction2011-Aug-16
PowerPivot Denali new DAX function to rank (RANKX)2011-Jul-18
PowerPivot Denali: Parent child using DAX2011-Jul-18
PowerPivot Denali: Working with multiple relationships between two tables2011-Jul-15
PowerPivot drillthrough in Denali CTP32011-Jul-13
Powerpivot CTP3: What is new for Time Intelligence functions2011-Jul-13
Denali PowerPivot: new DAX functions that will make your life easier2011-Jul-13
PowerPivot DAX case: Resouce planning report with selecting a date parameter2011-May-23
Get values within a Start and End date using PowerPivot DAX2011-Apr-04
Create a running total sparkline using PowerPivot DAX and Excel2011-Mar-30
Advanced DAX calculation: doing a moving grouped average in PowerPivot2011-Mar-22
Advanced DAX calculation: doing a moving grouped average in PowerPivot2011-Mar-22
Using the row context in PowerPivot DAX revisited2010-Dec-27
Why use the PowerPivot Time intel golden rules? With examples2010-Oct-12
Manage your PowerPivot datafeeds in a SharePoint datafeed library2010-Oct-07
Get the YTD of same period last year using DAX2010-Sep-22
Accumulate values (running value) over multiple years in PowerPivot using DAX2010-Sep-14
AVERAGEX – The 5-point palm, exploding fxn technique revisited2010-Sep-08
Project: Gain insight into your music taste using Last.fm, PowerPivot and the PivotViewer2010-Aug-31
Predict the future using Predixion data mining and PowerPivot2010-Aug-24
Datamining using PowerPivot and Predixion Insight2010-Aug-24
Determine the min value over rows in a group using MINX in PowerPivot2010-Aug-24
Importing data from SSAS into PowerPivot when you have different regional settings2010-Aug-12
Combine two sources (in our case ssas) using PowerPivot2010-Aug-11
Share your PowerPivot file with Excel 2007 users2010-Aug-11
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
 

Pyramid+PowerPivot