Create a new column which has value from last row

Question

Hi I am new to power query&nbsp;I would like to create two columns which have the fulfill date from the last row of column 1 and column 2.&nbsp;Please try to help&nbsp;Pic 1

anonymous · Accepted Answer

This should work:NewColumn1 = Table.AddColumn(PreviousStepName, "Date1", each List.Last([Column1])),NewColumn2 = Table.AddColumn(NewColumn1, "Date2", each List.Last([Column2]))&nbsp;--Nate

Forum Discussion

Create a new column which has value from last row

2 Replies

Related content

Create columns group

Creating a date column

Creating a custom column

unpivoting columns and creating datetime column

Appending columns and creating new column of old column headers