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
By row.
I've managed an if formula that gives me the correct values, but it fails with 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]
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
BCThat worked very well. Thank you very much for the help!
