filter only latest data based on person name

[deepuev]

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& A ?

[v-yuezhe-msft]

Hi @deepuev,

Please follow the guide in the article below to ask question in Q&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]

   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.

[v-yuezhe-msft]

Hi @deepuev,

What is the result when you ask question like"Last timein for each name " or "Highest timein for each name "?

Thanks,
Lydia Zhang

[deepuev]

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  sorted on timein as shown right side . I want only the row with highest(timein) entry per person .

Thanks ,

Deepak

[v-yuezhe-msft]

Hi @deepuev,

I test your sceanrio in Q&A using these keywords: Max timein/Maximum timein/Highest timein, the Q&A doesn't return the maxium value of timein column.  Currently, Q&A doesn't recognize these keywords:  Max,Maximum,Highest. Thus Max timein for each name /Maximum timein for each name/Highest timein for each name doesn't give expected result.

We have reported this issue internally, I will post back once I have any updates.

Regards,
Lydia Zhang

[deepuev]

Hi Lydia ,

Any reply you have got after you have reported this issue?

Thanks &

Regards,

Deepak

[v-yuezhe-msft]

Hi @deepuev,

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

Thanks,
Lydia Zhang

[ameyers_MSFT]

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.