Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I am trying to filter to only the most recent date, this is a small example of over 500k rows.
1. You can see that there are two sets of reading point for this shed, I am trying to filter to only the most recent arrival_datetime. There are also internal points so not just ne,nw,se,sw,cent. This structure is just small so only corners were done.
I had something like filter(max(arrival_datetime)), this is not correct.
Maybe a formula that has site number and room_name equal while taking the max of the arrival date to get the proper reading point.
Thank you,
Solved! Go to Solution.
Hi mkrapez,
I think you can do this by creating a new table to summarize your existing values.
Try the following (obviously replacing "Table1" and column names with your real names):
Table = FILTER(Table1,Table1[arrive_datetime]=CALCULATE(max(Table1[arrive_datetime]),ALLEXCEPT(Table1,Table1[site_number])))
Hope that helps,
Alex
Hi @mkrapez,
Sorry, I'm not sure what you're trying to do.
Is it a table with all values for a site_number with the most recent arrival_datetime?
What is the end result you would like to see?
Alex
Hi @alexei7,
I am trying to filter out the older values(get rid of them/delete them) and only keep the most recent values.
Some rooms may just have only one survey, so its fine but some have two surveys so we need to take only the most up to date values.
I put this data on a scatter plot with an X & Y Path and some of the rooms have points over top each other since the room was re-surveyed.
Thank you,
This is what the output looks like so all the variables on the left side have to be equal before we take the max of the arrival_dateTime.
So we have points on top each other in the scaterplott since there are two sets if a survey was done twice. And we want to take the most recent arrival_Datetime. I get errors where the older values appear when hovering over the points.
Does this help you understand more?
Hi mkrapez,
I think you can do this by creating a new table to summarize your existing values.
Try the following (obviously replacing "Table1" and column names with your real names):
Table = FILTER(Table1,Table1[arrive_datetime]=CALCULATE(max(Table1[arrive_datetime]),ALLEXCEPT(Table1,Table1[site_number])))
Hope that helps,
Alex
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
96 | |
69 | |
45 | |
39 | |
30 |
User | Count |
---|---|
155 | |
96 | |
60 | |
42 | |
41 |