PreviousRowValue
- Gvido
Returns the measure value of the preceding row (row above). The value is recalculated every time when changing visible row order by drilling into some dimension, ordering rows by measure, removing a row, changing the dimension on report rows, or other interactions with the report that change the visible row set.
Syntax
PreviousRowValue(<Expression>)Arguments
Expression | MDX expression that typically returns a measure, a tuple, or a string. |
|---|
Examples
For example, you may use PreviousRowValue() to see the delta of current and previous (above) row values. This works well if report rows are ordered to represent a specific workflow. This example shows changes in the measure "Hours spent" between the current row and the row above.
PreviousRowValue([Measures].[Hours spent])
- [Measures].[Hours spent]The following formula calculates duration in minutes from one issue creation till the next issue creation for issues visible in reports. Descending issue order by creation date is important for this measure to work as expected.
DateDiffMinutes(
[Issue].CurrentHierarchyMember.GetDate('Created at'),
PreviousRowValue([Issue].CurrentHierarchyMember.GetDate('Created at'))
)See also
Function VisibleRowsSet