Forum Discussion
Date Issue
Each time I use the created Date or Resolved Date in a new column or measure formula I receive an error that says "A single value for column "Created Date' in table x cannot be determined...." I am ...
krishnakanth240
Super User
Super UserHi njsimmons82
If you want Resolution Days per ticket as row by row then create Calculated Column instead Measure
Resolution Days =
DATEDIFF(
'June 1 to Aug 19'[Created Date],
'June 1 to Aug 19'[Resolved Date],
DAY)
In calculated column DAX evaluates it row by row, so there is an implicit row context and each row's own Created or Resolved Date is used with no error
If you want a measure then you need to use column in an aggregation as measure has to view many rows into one number
Avg Resolution Days =
AVERAGEX(
'June 1 to Aug 19',
DATEDIFF(
'June 1 to Aug 19'[Created Date],
'June 1 to Aug 19'[Resolved Date],
DAY))
AVERAGEX or SUMX iterates row by row internally computing DATEDIFF for each row and aggregates the results