Adding Column Removes Rows

[Dubbie999]

Hi,

I have a problem that I have never encountered before.  When a add a column, power query removes the previous years row.  The column formula is "If [LoadType] = "FTL" then [PlanShipDate] else [SchedShipDate]"  Can someone tell me why this happens and how to stop if from happening.

Thanks

[Dubbie999 · Accepted solution]

Thanks to all that responded.  I found the problem.  Someone changed the data table in the SQL database and the data was moved.

Thanks again

[VN999]

Please check this below options :

Check the Custom Column Formula:

• Verify that your custom column formula is correct. The formula you mentioned should look like this in Power Query M language:      CustomColumn = if [LoadType] = "FTL" then [PlanShipDate] else [SchedShipDate]
• Ensure No Unintended Filtering:Make sure there are no implicit filters applied in previous steps or within the formula itself. Sometimes, a filter applied in an earlier step can cause rows to be removed when adding a new column.

• Verify Data Types:

  • Check the data types of LoadType, PlanShipDate, and SchedShipDate columns. Incorrect data types can cause unexpected behavior. Ensure LoadType is a text type and PlanShipDate and SchedShipDate are date types.

[Legend_11]

Could you please provide the sample data and also could you review the power query steps, 

Please use the below formula maybe it is because of Nulls present in any of the columns,

if [LoadType] = "FTL" and [PlanShipDate] <> null then [PlanShipDate]
else if [SchedShipDate] <> null then [SchedShipDate]
else null