PreviousRowValue

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

CODE

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.

CODE

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.

CODE

DateDiffMinutes(
  [Issue].CurrentHierarchyMember.GetDate('Created at'),
  PreviousRowValue([Issue].CurrentHierarchyMember.GetDate('Created at'))
  )

Syntax

Arguments

Examples

See also