Forum Discussion

DataGirl90's avatar
DataGirl90
Regular Visitor
3 years ago

Find Previous 5 Minutes Value

Hi,    I'm looking to find the Sum of Value for the Previous 5 Minutes. I'm connected via Direct Query and am not able to use CALCULATE in a column. My Date Time field is in 5 minutes increment. Th...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Create a measure that implements your logic and use that measure as a visual filter.

DataGirl90's avatar
DataGirl90
Regular Visitor
3 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago
    There is a date slicer that users can use to select the dates they would like the data for

    is 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.