Forum Discussion
Solved
Power Query - Start and End Dates
Hello, I have a table with rates per company and a value per company. I want to extend the charges from a Start Date to an End Date. Can power query do this? Please see attached. thank...
Tony2021 Yes it can!
Attached a PQ solution that perhaps needs some optimising, but it's totally dynamic. You can add companies and/or change the dates, and it will be reflected when you refresh the green table.
To make it a bit easier, I added a column for the cost calculation to the raw data table.
Tony2021 Yes it can!
Attached a PQ solution that perhaps needs some optimising, but it's totally dynamic. You can add companies and/or change the dates, and it will be reflected when you refresh the green table.
To make it a bit easier, I added a column for the cost calculation to the raw data table.
Wow. YOu are quite talented with PQ. Thank you for your great assistance. Enjoy the day!