Forum Discussion
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...
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