Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cannot filter on date

Hello all, I have two huge CSV files that I have appended, but I really need to thin out the rows, as there are literally millions, So I am trying to filter anything older than 6 months, but if I tr...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I have figured out that the date error is itself an error, as if I change the filter to anything BEFORE 31/08/2019, it works, it just doesn't seem happy tying to filter dates after 01/09/2019.  Now I don't know if there is a limit to how many lines it can see in a CSV or if the fact that the CSV is always open and being written to all the time throws it.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Are you sure that you are on the last row of your query when you are trying to implement your filter? If you are on a row higher up before you converted to date time then that might be the cause. Only thing I can think of.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, Thanks for your response.

     

    Yes, it is the last action in the query.  I cannot use the DAX, as I want to get this done to the two seperate data sources befor they append together, so I need this to happen in the Query.