Forum Discussion
Power Query - Create new column based on latest date in two other columns
Hi again ,
try to add a condition in the begin to check if the signature date is null
someting like that:
if
[Opportunity History.First Signature Date] = null
then [Start_date__c]
else
if
[Start_date__c] >= [Opportunity History.First Signature Date]
then [Start_date__c]
else
if
[Opportunity History.First Signature Date] = "null"
then [Start_date__c]
else
[Opportunity History.First Signature Date]Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC
That will give the Start Date column only when Opportunity History is null right? The date is not always the latest in the Opportunity History column.
I've created a if/then/else formula for a custome column but it fails to take in to consideration the null values.
if [Start_date__c] >= [Opportunity History.First Signature Date] then [Start_date__c] else if [Opportunity History.First Signature Date] = "null" then [Start_date__c] else [Opportunity History.First Signature Date]