SSAS KPI Trend

KPI's (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in right direction based on previous levels. If you want to show a measure has increased or decreased since last month, this can be accomplished by using the MDX function PrevMember. You want the trend to show at the proper level only in excel. This way the users are not confused by extra trend graphics. This example will be using the adventure works cube and trend at the month level.