Forum Discussion
Solved
fill blank values with values in another column
Hi I have done most of my calculations in power query editor. As there are null values, I need to replace null values under Actual arrival date with values from Expected date of Arrival. How ...
Hi murali5431 ,
Just realized that the you have made the incorrect formula is not case but Table.
= Table.ReplaceValue(#"Time to complete entry",each [Vessel_Actual_Arrival_Date__c], each if [Vessel_Actual_Arrival_Date__c] <> null then [Vessel_Actual_Arrival_Date__c] else [Vessel_Estimated_Arrival_Date__c],Replacer.Replacevalue,{"Vessel_Actual_Arrival_Date__c"})
MFelix .. I am using Version: 2.83.5894.661 64-bit (July 2020)
Hi murali5431 ,
Just realized that the you have made the incorrect formula is not case but Table.
= Table.ReplaceValue(#"Time to complete entry",each [Vessel_Actual_Arrival_Date__c], each if [Vessel_Actual_Arrival_Date__c] <> null then [Vessel_Actual_Arrival_Date__c] else [Vessel_Estimated_Arrival_Date__c],Replacer.Replacevalue,{"Vessel_Actual_Arrival_Date__c"})