Create a new column which has value from last row

[chuongtt]

Hi I am new to power query

I would like to create two columns which have the fulfill date from the last row of column 1 and column 2. 

Please try to help Pic 1

[Anonymous · Accepted solution]

This should work:

NewColumn1 = Table.AddColumn(PreviousStepName, "Date1", each List.Last([Column1])),

NewColumn2 = Table.AddColumn(NewColumn1, "Date2", each List.Last([Column2]))

--Nate

[Jakinta]

You can remove rows that contain: "Order" and "Date" then FillUp.