Forum Discussion
Solved
column ref to 'createdon' cannot be used with a variation 'Date' because it does not have any.
Hi There, new to Power BI and looking for a little help/advice on this error. we have 2 different reports created in Desktop, 1 is using direct Query, and the other Import for the data. the ...
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,
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
Community Champion
Community ChampionI 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.
- Stachu
good luck :)