Forum Discussion

Dubbie999's avatar
Dubbie999
New Member
2 years ago
Solved

Adding Column Removes Rows

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...
Need Help
  • Dubbie999's avatar
    Dubbie999
    2 years ago

    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's avatar
VN999
Icon for Resolver I rankResolver I
2 years ago

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.