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

Legend_11's avatar
Legend_11
Resolver I
2 years ago

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