cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
deepuev
Regular Visitor

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

8 REPLIES 8
Microsoft
Microsoft

Re: filter only latest data based on person name

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
deepuev
Regular Visitor

Re: filter only latest data based on person name

 

Screen Shot 2016-12-14 at 3.03.29 PM.png

Screen Shot 2016-12-14 at 2.41.49 PM.png

 

   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.

 

Microsoft
Microsoft

Re: filter only latest data based on person name

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
deepuev
Regular Visitor

Re: filter only latest data based on person name

Screen Shot 2016-12-15 at 6.25.42 PM.png

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

Microsoft
Microsoft

Re: filter only latest data based on person name

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
deepuev
Regular Visitor

Re: filter only latest data based on person name

Hi Lydia ,

 

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

 

Thanks &

Regards,

Deepak

Microsoft
Microsoft

Re: filter only latest data based on person name

Hi @deepuev,

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

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft
Microsoft

Re: filter only latest data based on person name

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.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.