 |
| |
|
|
|
 |
|
|
Entries for 'Javier Guillen'
Javier Guillen posted on September 10, 2011 21:03
PowerPivot currently has no programmatic interface, so there is really no automated way to leverage its capabilities (other than those provided by Pow...
[Read the rest of this article...]
Javier Guillen posted on July 12, 2011 23:14
Javier Guillen posted on July 08, 2011 23:48
Javier Guillen posted on July 03, 2011 22:49
How to calculate median over a PowerPivot measure
[Read the rest of this article...]
Javier Guillen posted on July 02, 2011 00:14
A common calculation required in business is moving averages. How can we create it in DAX? Lets walk through the calculation.
Imagine we have t...
[Read the rest of this article...]
Javier Guillen posted on May 01, 2011 16:13
Presentation slides for PASS VC webinar on PowerPivot and DAX
[Read the rest of this article...]
Javier Guillen posted on April 28, 2011 14:42
PowerPivot can be a really powerful tool for prototyping Business Intelligence projects.
[Read the rest of this article...]
Javier Guillen posted on April 28, 2011 14:34
I will be speaking tomorrow for the Professional Association for SQL Server (PASS) Business Intelligence Virtual Chapter; my topic will be...
[Read the rest of this article...]
Javier Guillen posted on April 03, 2011 21:41
Slicer values in PowerPivot calculation: Restricting DAX filter context to values in query context
[Read the rest of this article...]
Javier Guillen posted on March 30, 2011 09:53
How to re-enable the PowerPivot add-in in case Excel removes it from the ribbon
[Read the rest of this article...]
Javier Guillen posted on March 04, 2011 09:20
Recently, I encountered a situation that required the use of SUMX as part of a DAX measure. Interestingly, SUMX seemed to only be taking in the ...
[Read the rest of this article...]
Javier Guillen posted on March 03, 2011 11:53
On March 19, I will be speaking about DAX Evaluation Context at SQL Saturday # 70 in Columbia, SC. As part of the presentation, I will comp...
[Read the rest of this article...]
Javier Guillen posted on February 24, 2011 22:06
One of the interesting DAX Time Intelligence functions is the TOTALYTD, which can define a measure calculation over a year in a cumulative way.
The ...
[Read the rest of this article...]
Javier Guillen posted on February 12, 2011 21:32
When building PowerPivot-based custom reports, authors can use DAX measures on Cube formulas, just as they have been able to do with traditional SSAS OLAP measures. MDX can also be applied over Vertipaq dimension attributes in order to create custom sets that can be reused over the custom report.
[Read the rest of this article...]
Javier Guillen posted on December 19, 2010 22:59 
How to use multiple slicer selected values in an Excel cube formula
[Read the rest of this article...]
Javier Guillen posted on November 16, 2010 22:12
Cube formulas can be used to query DAX measures
[Read the rest of this article...]
Posted in: SSAS, MDX, Blog
Javier Guillen posted on October 28, 2010 21:12
PowerPivot and Excel Cube functions can work together to create highly customized reports
[Read the rest of this article...]
Javier Guillen posted on September 28, 2010 21:48
The new SSAS database architecture used in PowerPivot offer some exciting advantages for BI applications
[Read the rest of this article...]
Javier Guillen posted on September 08, 2010 13:10
One of the things I am fascinated with is how familiar data manipulation tools like Excel can be powerful BI enablers. While tradi...
[Read the rest of this article...]
|
|
|
|
|
|
| |
|
|