Forum Discussion
DAX is not identifying the date fields
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
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
