Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
40
Views
Topic starter
Hi folks,
Hoping for some direction on what is the method to distribute Annual GL Line Budget values loaded into PQ across the months to which the Job Code is being budgeted. Could be between 1 - 12 months dependant on Job Start and End Month.
Data provided in attachment and example of required output.
Thanks for any assistance
Posted : 27/06/2025 3:16 pm
Attached workbook contains one way to deal with it. The query is quite crude but works for a relatively straight-forward task like yours.
Since you seem to have the table with start and end dates in Excel, do yourself a favour and add a column that calculates the number of months like I did.
Posted : 27/06/2025 4:40 pm
