Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Previous Registration with Filters

Hi everyone, I have the following table

The Date column is ordered decently, I would like to have the previous date for each record and with this measure I get it

fecha anterior = 
CALCULATE(
    SELECTEDVALUE(Accidentes[fecha]),
    OFFSET(-1,ALLSELECTED(Accidentes[fecha])
    )
)

but when I filter by the Area column I get this

and this is not what I need, in "previous date" it is showing me the value as if it was not filtered, where it says 4Oct 2020 it should show me 15 Mar 2022 and it is showing 9sep2022 (which is the value without the filter)

I hope you have let me understand my need and if you can help me.

Best regards