Forum Discussion
Solved
filter data on report refresh time
We have data in following format from Direct query and I need to filter a graph on last refresh time i.e. timestampvalue from "TIMESTAMP" column equal to timestampvalue from "Current time" trie...
Hi sumneshnepalia ,
This logic you're talking about holds true in the row context when creating calculated columns:
And I created a measure, at this point the filter context works, you can also use SELECTEDVALUE instead of MAX:
You can test the formula I've given and let me know if you have any problems, or clarify in your next reply if I've misunderstood what you've said.
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
what if you use a table visual and group by timestamp?
lbendlin how can I filter it for current timestamp as I have rows for eevery minute
Try it out. Power BI will automatically group for you.