cannot find date value

[Anonymous]

Hello All, 

This is my first try of Power BI,  trying to figure out many new things, and get stuck with calcuating the datediff field. 

The issue is that it won't read my date field automatcially from the table, and I checked the field "ASOFDATE"  and "DUEDATE" are both the date type.  so I manually entered  the two but recived the below warning message.     ( I watched  some introduction vedio online, in theroy, the field options will pop up when entering the formula, but I don't see any option... )..

Anything critical I am missing here?  Any help is apperciated.  

Thank you,

Flora

DayDiff = DATEDIFF( 'Details'[ASOFDATE],'Details'[DueDate],day) 

"A single value for column 'ASOFDATE' in table 'Details' cannot be determined. This 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."

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[Ashish_Mathur]

Hi,

Try this

=MAX('Details'[DueDate])-MAX('Details'[ASOFDATE])

Hope this helps.

[Greg_Deckler]

You are trying to create a measure, so you need to use an aggregation of MAX or MIN, for example around your date columns ASOFDATE, DueDate.