Forum Discussion
Find Previous 5 Minutes Value
Super Useruse two relative time filters on your visual. Something like this:
- is in last ten minutes
- is not in last five minutes
Hi,
Applying a visual level filter would filter out the other fields in my matrix though. Also, I should have provided more information. There is a date slicer that users can use to select the dates they would like the data for.
- lbendlin
Create a measure that implements your logic and use that measure as a visual filter.
Hi,
That's what I was asking for help with. I've updated the question with some more DAX and I was wondering if there is a better way to write the DAX. Also, I'm not sure what you mean by creating a measure and using that measure as a visual filter. I don't think that using a measure to apply a visual filter would satisfy the requirements of the report. As I've explained above, if I apply a filter on the visual, the dates would have to match the dates the users will select in the date slicer seeing as it is expected report behavior that all the visuals on the report page will interact with each other. And what measure were you thinking of specifically that I should use as a filter? My main problem in the initial post was calculating the data for the previous 5 minutes from the selected date time and then calculating the % change from it.
- lbendlin
There is a date slicer that users can use to select the dates they would like the data foris that fed from your fact table or from a connected dimension table (which would be weird because of the 5 minute granularity)?
I tested with measures and it works fine even considering the selection slicer being fed from the fact table.