Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I had a new column with the DATEDIFF working fine and suddendly stoped working.
Age = DATEDIFF(utcnow()+ 'Contas correntes de clientes'[dataven]+ DAY)
I was calculating the number of days between today and a sql column date with a previous date.
Now i have this error:
Too few arguments were passed to the DATEDIFF function. The minimum argument count for the function is 3.
Solved! Go to Solution.
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 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))).
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)
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |