Forum Discussion

mkrapez's avatar
mkrapez
Frequent Visitor
8 years ago
Solved

Advanced Filter need HELP Multiple Variable

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 filt...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • alexei7's avatar
    alexei7
    8 years ago

    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

mkrapez's avatar
mkrapez
Frequent Visitor
8 years ago

 

alexei7 this is for the post above

alexei7's avatar
alexei7
Continued Contributor
8 years ago

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