filter only latest data based on person name

Question

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 highest value of a column for a spcific person . Each row will contain person name , rank ( a number derived from current time where the latest will always be the highest) and some other parameters as rest of the columns. So i wanted to show only the last enrty for a person based on highest value of rank. Can i do this using Q&amp; A ?

ameyers_msft · Answer

Hi deepuev, I'm from the Q&amp;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&amp;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.&nbsp;As a side note, "maximum" / "minimum" / "highest" terms are recognized when working with numeric data but "earliest" / "latest" are recognized for date/time data.

anonymous · Answer

Hi deepuev,
Please follow the guide in the article below to ask question in Q&amp;A. In your scenario, you probably need to use something like “person with highest entry” or “Latest entry for person” as question.https://powerbi.microsoft.com/en-us/documentation/powerbi-service-q-and-a-tips/ 
Thanks,Lydia Zhang

deepuev · Answer

&nbsp;&nbsp;&nbsp;&nbsp; Using the query " name station timein latest timein as table " i get the left side result . But what i want is to filter the rest of the entries which are not latest data for a person. From the left side output image , i want only the highlighted entries to be visible as shown right side image .These are current positions and do not want to show the rest which are not highlighted.&nbsp;

anonymous · Answer

Hi deepuev,What is the result when&nbsp;you ask question like"Last timein for each name " or "Highest timein for each name "?Thanks,Lydia Zhang

deepuev · Answer

Hi Lydia,When i try using the following query as you have suggested "name timein station highest timein for each name as table " , the output i get is a list sorted by name and timein . It does not filter out the non highest rows . So the output is a list all values for a person and then for next&nbsp; sorted on timein as shown right side . I want only the row with highest(timein) entry per person .&nbsp;Thanks ,Deepak

Forum Discussion

filter only latest data based on person name

8 Replies

Related content

Latest Date Filter

Personal Bookmark Overwriting Updates to Filter Pane

Personal Gateway issue

Latest date filter

Filter Latest Quarter