Forum Discussion
Solved
Filter table dynamicaly on dates
Hello community, I'm trying to get a table (or measure) which is filtered through dates. What I want to achieve is to filter the table on "begindatum" (which is starting date in English) and I o...
Renco wrote:
With an OData connection or any other 'import' connection this works like a charm. However with a DirectQuery connection this solution is not possible.
So if someone knows another way to achieve this goal, suitable for a DirectQuery connection, I'm looking forward to hearing it.
Thanks in advance.
In DirectQuery mode, say if the data source is SQL Server, you can create the columns in SQL instead of in Power BI desktop. Then you can still apply filter to the true/false column.
Thanks for your reply. I am familiar with this possibility. Currenty we do it like this. However I'm looking for a way that doesn't involve editting the SQL database.