Forum Discussion
Anders_G
Helper I
4 years agoPower Query - Create new column based on latest date in two other columns
Hi, I want to create a new column in Power Query with the latest date found in the below mentioned two columns. The column on the right might have Null values. If so, the date in the left column ...
- 4 years ago
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
Anders_G
Helper I
4 years agoThat worked very well. Thank you very much for the help!
onurbmiguel_
Power Participant
4 years agoyou are welcome.
BR
Brunoi