DAX is not identifying the date fields

[Ajaikumar]

I'm trying to get the number of days between two dates. For that, I tried to use the DATEDIFF function but the date fields are not showing up in IntelliSense and if I try to enter it manually it shows an error that is in the figure below:

Please let me know what is wrong with this expression. Thanks in advance.

[Anonymous · Accepted solution]

Hi @Ajaikumar ,

As checked your screenshot, what you are trying to create is a measure. That is the cause of problem. This errror can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result. You can review the following blog for more details.

DAX error messages in Power BI

And the solution is that you can create a calculated column as below to replace this measure...

R value = DATEDIFF ( calendar[Date], TODAY (), DAY )

In addition, you can refer the following blog to get the difference between two dates.

Power bi Date Difference

Best Regards

[Ajaikumar]

Thank you for the solution @Anonymous 

[tamerj1]

Hi @Ajaikumar 

perhaps you're trying to create a new Calculated Column but in fact you created a Measure instead