Forum Discussion
Solved
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 ...
The error occurs because you’re creating a measure, but [Created Date] and [Resolved Date] contain multiple rows. DAX needs an aggregation or a single selected value.
maybe you can try this
Resolution Days =
VAR CreatedDate =
SELECTEDVALUE('June 1 to Aug 19'[Created Date])
VAR ResolvedDate =
SELECTEDVALUE('June 1 to Aug 19'[Resolved Date])
RETURN
IF(
NOT ISBLANK(CreatedDate) &&
NOT ISBLANK(ResolvedDate),
DATEDIFF(CreatedDate, ResolvedDate, DAY)
)
if this does not work, pls provide your sample data and expected output.
v-aatheeque
Community Support
Community SupportHi njsimmons82
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.