Forum Discussion
DATEDIFF, calculate days between today and SQL date field, error
Seems like this should be the one:
Age = DATEDIFF(UTCTODAY(), 'Contas correntes de clientes'[dataven], DAY)
Is this a column or a measure?
This is what worked for me in a standard Calendar table:
Column = DATEDIFF(UTCTODAY(), [Date], DAY)
Community ChampionIt seems like you have plus symbols (+) where you should have commas (,) or semi-colons (;).
I am unaware of a regional language variation that uses + symbols like that...
I've tried with this both syntax:
Age = DATEDIFF(UTCTODAY(); 'Contas correntes de clientes'[dataven]; DAY)
and
Age = DATEDIFF(UTCTODAY(), 'Contas correntes de clientes'[dataven], DAY)
And the error now is:
The syntax for ';' is incorrect. (DAX(DATEDIFF(UTCTODAY(); 'Contas correntes de clientes'[dataven]; DAY))).
- Greg_Deckler
Seems like this should be the one:
Age = DATEDIFF(UTCTODAY(), 'Contas correntes de clientes'[dataven], DAY)
Is this a column or a measure?
This is what worked for me in a standard Calendar table:
Column = DATEDIFF(UTCTODAY(), [Date], DAY)
- It’s a column. I was aware of that limitation in measures.
Could it be possible due a direct query limitation on last power bi update ?
Since it was working before
Anyway you’re using DATE field without quotations and on my side when I select a sql field automatically places inside quotation ‘ xxxx ‘
