Forum Discussion
Advanced Filter need HELP Multiple Variable
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 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