Forum Discussion
DAX is not identifying the date fields
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.
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.
Best Regards
3 Replies
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.
Best Regards
Thank you for the solution Anonymous
