PrevMember (PEL)

This function returns the previous member in the level that contains a specified member.



  • Member_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a member

Return value

The PrevMember function returns the previous member in the same level as the specified member.


The PEL compiler can always generate SQL code for this function.

This function is defined as Member_Expression**.Lag(1)**. For more information, see Lag (PEL).

PEL cannot be used to reference user-created member views in non-time dimensions. To write a business rule that references a member view in a non-time dimension, use a native Multidimensional Expressions (MDX) implementation.

See Also


Lag (PEL)
SQL generation for PEL functions

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN