Forum Discussion
Helper IHelp on create new column based on 2 other columns
Hi Alvarom1
Yes, use the arrow next to the column header in the Power Query Editor to set the sort order.
Sort the Invoice column Ascending, then the Payment Date column descending.
Once that's done, apply the Fill Down on the Payment Date column.
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.
Solution SageHi Alvarom1
Rather than creating a new column, you can use the Power Query 'Fill' function to fill down the dates in your exisiting column:
- Open the Power Query Editor and select your query
- Select the Payment Due column
- Navigate to Transform menu then select Fill > Down
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.
Alvarom1Thanks Martin,
another issue. Some values on the table are not on the first line of each invoice. Then when I do as you suggest it takes dates from previous invoice. Is there a way to order by two columns? First Invoice, then the value on the second column and after that do the Fill down?
I hope is clear
thanks!
Alvaro
- MartynRamsden
Hi Alvarom1
Yes, use the arrow next to the column header in the Power Query Editor to set the sort order.
Sort the Invoice column Ascending, then the Payment Date column descending.
Once that's done, apply the Fill Down on the Payment Date column.
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.- Alvarom1
Great. it works
Thanks a lot Marty
Good day
Alvaro