Use MDX for chain search

This and previous periods are often compared in a report query, such as March sales and February sales. Generally there are absolute and relative value points,
If this period increment = Current period value-the value of the previous period;
Current Period increase = (current period value-previous value)/current period value; relative value
1:MDX this query
With member [Time2]. [This period increment] as ' [time2]. [All Time2]. [1997]. [Q1]. [3]-[time2]. [All Time2]. [1997]. [Q1]. [2] '
Member [Time2]. [Current increase] as ' [time2]. [This period increment]/[time2]. [All Time2]. [1997]. [Q1]. [3] '
Select
{[time2]. [All Time2]. [1997]. [Q1]. [3],[time2]. [All Time2]. [1997]. [Q1]. [2],
[Time2]. [This period increment],[time2]. [Current Increase]} On columns,
{[Measures]. [Store Sales]} On Rows
From Sales
March and February compared to sales increase and increase.
Note: 1 If there is no previous member, the value is 0;
2 MDX provides the PrevMember function to represent the previous member, [All Time2]. [1997]. [Q1]. [2] can be used [all Time2]. [1997]. [Q1]. [3].
PrevMember instead.
2: Solve Order
If more than one calculated member is generated and a calculated member uses another calculated member, the Solve_order is used to indicate the build order
Such as:
With member [Time2]. [This period increment] as ' [time2]. [All Time2]. [1997]. [Q1]. [3]-[time2]. [All Time2]. [1997]. [Q1]. [2] '
, Solve_order = 1,
Member [Time2]. [Current increase] as ' [time2]. [This period increment]/[time2]. [All Time2]. [1997]. [Q1]. [3] '
Solve_order = 2