Use previous row in eazyBI calculated measure

Daniel Barnett
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 14, 2017

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?

1 answer

0 votes
Oskars Laganovskis
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 10, 2023

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.


Oskars / eazyBI support

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events