Use previous row in eazyBI calculated measure

[Daniel Barnett]

I have a table where there is a row for each month, and 3 columns:

1. Issues Created

2. Issues Resolved

3. Open Issues

I want to add a fourth column which is Issues Resolved minus the previous row's Open Issues, but I can't figure out how to reference the previous row in my calculated measure.

Can anyone help?

[Oskars Laganovskis]

Hi @Daniel Barnett ,

As of eazyBI version 6.5 or on eazyBI Cloud, you might use the eazyBI function PreviousRowValue() to access the values of the previous row.

Regards,

Oskars / eazyBI support