Forum Discussion

RogerSteinberg's avatar
RogerSteinberg
Icon for Post Patron rankPost Patron
7 years ago
Solved

Lookup previous value based on criteria from another column

Hi All,   I would like to get the value that preceedes based on the earlier date. The value needs to also match the group number.   My table looks like that: +------------+-------+-------+------...
Need Help
ElenaN's avatar
ElenaN
Icon for Resolver V rankResolver V
7 years ago

Hello,

 

You can try the following modification marked with blue:

 

RateChange = 
CALCULATE(
    VALUES(table[Rate]),
    FILTER(
        ALL(table),
        table[date] < EARLIER(table[date])  && table[group] = EARLIER(table[group])
    )
)

Regards,

ElenaN