Getting Started with Adobe After Effects - Part 6:
A blog about Business Intelligence, with particular emphasis on SQL Server Analysis Services technology including PowerPivot, DAX, SSAS BISM Tabular and Multidimensional and MDX.
Browse by Tags ·
OFFSET double lookup in PowerPivot
One of those really great functions in the native Excel environment is OFFSET. In combination with other functions like MATCH, it can generate a type of ‘double lookup’ that can be really helpful when creating dynamic reports. For example, the ...
Posted on Mar 8 2012 12:00AM
USERELATIONSHIP and direction of context propagation
My friend Hrvoje Piasevoli ( twitter ) pointed out to me recently that when using USERELATIONSHIP in a calculated column, the output was not the expected value based on the selected relationship. I have used USERELATIONSHIP successfully in DAX measures a...
Posted on Mar 5 2012 12:00AM
Detecting Total, Subtotal and Hierarchy Levels in PowerPivot
Recently I participated on a thread on the PowerPivot MSDN forums in which it was asked how to detect the level you are on in the pivot table hierarchy in order to conditionally handle the output of a measure. As I think this is a fairly simple topic but o...
Posted on Feb 20 2012 12:00AM
Simulating an "approximate match" VLOOKUP in PowerPivot
It is often said that relationships in PowerPivot work in a similar way to VLOOKUPs. In reality, this is only partially true. If we examine the claim a bit closer we realize that Excel’s VLOOKUP function has a parameter in which it is possible to use an a...
Posted on Feb 10 2012 12:00AM
Copyright © Rivera Informatic Private Ltd