Forum Discussion
Power Query - Start and End Dates
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 That's very well possible. but it would be some guesswork without more information. How does that "other table" look like?
If you have tables with matching company names, you can use the merge function(s) in PQ to create a table like the one in the example, and then build further with that one.
Riny_van_Eekelen Hi Riny, thanks for the response.
I have attached a file that has the dates of the increase or decrease of the amount.
Would be interested in knowing how that could be incorporated.
grateful for your assistance.
Tony2021 Not sure if PQ is the right tool for this kind of work. Importing, cleaning and transforming is what PQ does best, in my opinion. You ask for a dynamic calculation of costs over time, for multiple companies. It seems to me that it is much easier done in Excel itself. any particular reason why you insist on using PQ?
- Hi Riny I do have the calculations in excel but thought possibly PQ could make it easier somehow. Your answer confirms that PQ is not really meant for this and doing in excel might be easier. Thank you for your insight. Much appreciated.
Tony2021 Well, don't take my word for it. Just my personal opinion! I wouldn't use PQ for such calculations.