Automate Allocation of Amounts Across Months Using Power Query
Let’s assume you have an amount, start date, and end date. You need to split that amount into months based on the exact number of days in each month. also, keep in mind that the start and end months may be incomplete. This video shows you exactly how to do it using Power Query
Did I answer your question? Mark my post as a solution!