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.
Ashish_Mathur
Super User
Super UserHi,
You will have to warp that column with a function such as min().