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
Hi Anders_G ,
Add a conditional column where Opportunity History = null then Start_date_c else Opportunity History.
This should do it for you.
Did I help you today? Please accept my solution and hit the Kudos button.
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]