Forum Discussion
Syndicate_Admin
2 years agoAdministrator
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
Hi,
PBI file attached.
Hope this helps.
5 Replies
- Ashish_MathurSuper User
Hi,
Share the download link of the PBI file.
- Syndicate_AdminAdministrator
Hello, thanks for the reply, I attach the PBIX
- Ashish_MathurSuper User