Forum Discussion
NEW date column based on condition
Hi, I have 2 dates column and I want to create a new date column based on the Last PODdate and FirstPOD date. The logic is as follows: New PoDDateColumn= If the FirstPOD date has a value...
I solved this problem on my own using a very simple trick. I trimmed the dates and then inserted null in the blanks. After inserting "null" in place blanks. I was able to get what I wanted. using the same coalesce function using ??
= Table.AddColumn(#"Changed Type", "Final_PodDate", each [FirstPODDate]??[LastPODDate])
Yep, which is why I said above, you'll need to convert blanks to nulls.
Glad you got it worked out.
Add a custom column where you concatenate the two fields and then extract the first 8 characters (assuming that the data types are text)
Text.Start(Text.Combine({[FirstPODDate], [LastPODDate]}, ""), 8 )
If the data types are numeric then the coalesce should work