Forum Discussion
Solved
Combining 2 Date Fields into 1
I have 2 date fields in the same table in my database: Date Field 1 and Date Field 2. Date Field 1 always contains data; Date FIeld 2 sometimes contains data. What I'd like to do is create a new da...
What about creating a custom column using the Query Editor? You could add a column with the following statement (replace the text in green with your field names:
if [Date 2] <> null then [Date 2] else [Date 1]
It would result in something like this:
Will the below DAX work for you?
New Date = IF(ISBLANK(Sheet1[Date 2]), Sheet1[Date 1], Sheet1[Date 2])
No, I get the following error:
"A single value for column '[Date Field]' 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."
Any other suggestions?
