Forum Discussion
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...
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.
Power BI setup is required to support DD/MM/YYYY kind of date. If you have done that
Then have date column to join with date table
Date = Table[Datetime].date
If you date calendar is in mm/dd/yyyy format
then
Date = Date(right([datetime],4),mid([datetime],4,2),left([datetime],2))