Forum Discussion
Filtering a date column
Hello Pete,
I split that table because its too large to be treated, so i need a table with "hot" data which is data with the last 4 months, and "cold" data, which is the data prior to those last 4 months.
I`ve tried the formula you`ve writen, unfortunaly it dindt work:
Samuel.
Super User
I'm not sure what you mean by "too large to be treated". You're using Direct Query so no actual data is being loaded to the model. Any transformations you make will be folded back to the source, so there should be no issues with size whatsoever. For the record, I don't think you should be trying to split your table like this at all when using a Direct Qury model. However:
...regarding the failed filter: when you say it's not working, what do you mean? Is it not giving you the required output, or are you getting an error message?
Pete