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

watch?v=O3AnAKjRBLM