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 not sure how to get around this. My data source is excel and created date is a column with a date and time but I formatted it to just m/dd/YY.
2 Replies
If the goal is to calculate the duration for each record, The 'Resolution Days' column with DATEDIFF() calculated column should be created in 'June 1 to Aug 19' table, not the Calendar table.
Hi,
You will have to warp that column with a function such as min().
