Forum Discussion

scooby1380's avatar
scooby1380
New Member
8 years ago
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 ...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    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?

scooby1380's avatar
scooby1380
New Member
8 years ago

Hi Stachu,

 

many thanks ill look into re-writing it.

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

good luck :)