Sign in
|
Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules
Getting Started with Adobe After Effects - Part 6:
Motion Blur
Liked
Syndicated Blogs
Upload Image
Close it
Select File
A blog about Business Intelligence, with particular emphasis on SQL Server Analysis Services technology including PowerPivot, DAX, SSAS BISM Tabular and Multidimensional and MDX.
Like
Invite Friends
Browse by Tags ·
View All
SSAS
31
PowerPivot
17
BI Community
4
DAX
4
DAX patterns
2
Tabular Relationships
2
Insights
1
What-if analysis
1
Excel functions
1
VLOOKUP
1
Archive ·
View All
August 2012
7
July 2012
4
March 2012
4
January 2013
3
May 2012
3
April 2012
3
February 2012
3
March 2013
2
December 2012
2
November 2012
2
Javier Guillen
Home
·
Most Liked
·
Most Discussed
·
Fans (16)
·
Preferences
2
Liked
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 ...
JavierGuillen
Posted on Mar 8 2012 12:00AM
Profile
2
Liked
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...
JavierGuillen
Posted on Mar 5 2012 12:00AM
Profile
1
Liked
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...
JavierGuillen
Posted on Feb 20 2012 12:00AM
Profile
1
Liked
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...
JavierGuillen
Posted on Feb 10 2012 12:00AM
Profile
Copyright © Rivera Informatic Private Ltd
Contact us
Privacy Policy
Terms of use
Report Abuse
Advertising
[ZULU1097]