New Measure: DAX DateDiff issue - Date Hierarchy?

[totem1248]

I'm trying to create a MEASURE that will calculate the difference in dates between two date fields. (Start date & end date)

Both Start_date and end_Date have data hierarchies and are in 'date' format mm/dd/yyyy.

Delta = DATEDIFF('Table'[Start_date], 'Table'[End_Date], Day)

But I get the error:

"A single value for column 'Start_Date' in table 'Table' 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."

Both columns have the same date format. Does this issue have anything to do with both date columns having a hierarchy (day/month/quarter/year)?

[totem1248 · Accepted solution]

If you do a calculated column, I get the result that is needed. Solved!

[v-easonf-msft]

Hi , @totem1248 

Glad to hear that you have worked it out. Would you please  accept your reply as solution to close this thread so that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason