asked on

In Power BI report display the latest interval of results in a table

I am using Power BI Report Server with Power BI Desktop (September 2019). I have imported in a CSV file and I am having problem adjusting the output the way I need. The data consists of a server name, date, and a count. I have also created a new column that sets a location using a SWITCH measure based on the server name.

The CSV contains results in five minute intervals for over a week for each server. My problem is getting the table to just display the latest reports. Below is an example of my table. Is there a way to just show the latest five minute interval by location, server, and count?

Thank you for the assistance.
Current_Results.JPG
Desired_Results.JPG

ASKER CERTIFIED SOLUTION

Tom Farrar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tom Farrar

If you need a workaround until you find the BI solution, you can do the following with your data in Excel. Make a table out of the data, sort descending by account, highlight all the data in the fields except the Date field, and use Data>Remove Duplicates. This should leave you with the unique records with the most recent date. An example is attached. Try it if you need a quick workaround.
EE.xlsx

Tom Farrar

Actually you could probably go through the process I previously described in Power Query and it would record the process of sorting the dates descending and getting rid of the duplicate records for the other fields. Once recorded it should work going forward as data changes. Might try this.

Jeffrey Renfroe

ASKER

Not sure how I missed. Thank you for the quick response.

Tom Farrar

Your welcome.