Forum Discussion

deepuev's avatar
deepuev
Regular Visitor
9 years ago

filter only latest data based on person name

I wanted to filter only the latest data and show it on powerBI . The data is coming from azure stream analytics. The data is about a person presence at a location .The dash board should show only hig...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi deepuev,

The team is working on this issue, I will post here if I get any updates.

Thanks,
Lydia Zhang

ameyers_MSFT's avatar
ameyers_MSFT
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi deepuev, I'm from the Q&A development team. As you've noticed, we interpret "latest" as a sorting request rather than a filter/aggregation. This is primarily a limitation of the visualization query engine. For your specific example, if you expand the Visualizations pane on the right in Q&A, click the small arrow icon for the "timein" field and change the "Don't summarize" setting to "Latest" then you will get the result that you want.

 

As a side note, "maximum" / "minimum" / "highest" terms are recognized when working with numeric data but "earliest" / "latest" are recognized for date/time data.