Forum Discussion

Samuel_sousa's avatar
Samuel_sousa
Regular Visitor
3 years ago

Filtering a date column

Hello,   Let me put you on context first:   1. There are two tables in direct query connection mode   2. I have one fact Table which i had to split in two, the criteria to split both is the dat...
General Comment
Need Help
Tips and Tricks
BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Samuel_sousa ,

 

Two things:

1) You try a filter condition something like this:

[DateColumn] <= Date.AddMonths([DateColumn], -4)

 2) Why have you split the table in the first place? In a Direct Query model, nothing is loaded to the model, so it's not a space- or time-saver. You can make these timebound distinctions in the data with measures for much greater performance.

 

Pete

  • Samuel_sousa's avatar
    Samuel_sousa
    Regular Visitor
    3 years ago

    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.

    • BA_Pete's avatar
      BA_Pete
      Super User
      3 years ago

       

      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