Forum Discussion
column ref to 'createdon' cannot be used with a variation 'Date' because it does not have any.
I think switching to import should be the last resort, I'd suggest rewriting current syntax using DATEADD to something using e.g. FILTER etc. - if possible
can you share the syntax that gives the error & the structure of the tables included?
Community Championis it time intelligence related measure? they do not work in Direct Query
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery
https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=sql-server-2017
Hi Stachu,
thank you for the response.
we are using DATEADD, so by your response we would need to swith the mode to Import to get use of these?
many thanks
scott
- Stachu
I think switching to import should be the last resort, I'd suggest rewriting current syntax using DATEADD to something using e.g. FILTER etc. - if possible
can you share the syntax that gives the error & the structure of the tables included?Hi Stachu,
many thanks ill look into re-writing it.
