https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Automate-Allocation-of-Amounts-Across-Months-Using-Power-Query/m-p/3944339#M763 <P><SPAN><SPAN class="">it has monthly distributed amount and i am looking for quarterly&nbsp;</SPAN></SPAN></P><P><SPAN><SPAN class="">i have to split mount to fiscal quarter like on this blog he has split for months&nbsp;</SPAN></SPAN></P><P>&nbsp;</P><P><SPAN><SPAN class="">how we can do this?</SPAN></SPAN></P> Thu, 23 May 2024 14:59:45 GMT Anonymous 2024-05-23T14:59:45Z https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Automate-Allocation-of-Amounts-Across-Months-Using-Power-Query/m-p/1860112#M244 <P><SPAN>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</SPAN></P> <P><SPAN class="videoUrl hidden">watch?v=O3AnAKjRBLM</SPAN></P> Mon, 24 May 2021 10:57:19 GMT https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Automate-Allocation-of-Amounts-Across-Months-Using-Power-Query/m-p/1860112#M244 Fowmy 2021-05-24T10:57:19Z https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Automate-Allocation-of-Amounts-Across-Months-Using-Power-Query/m-p/3944339#M763 <P><SPAN><SPAN class="">it has monthly distributed amount and i am looking for quarterly&nbsp;</SPAN></SPAN></P><P><SPAN><SPAN class="">i have to split mount to fiscal quarter like on this blog he has split for months&nbsp;</SPAN></SPAN></P><P>&nbsp;</P><P><SPAN><SPAN class="">how we can do this?</SPAN></SPAN></P> Thu, 23 May 2024 14:59:45 GMT https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Automate-Allocation-of-Amounts-Across-Months-Using-Power-Query/m-p/3944339#M763 Anonymous 2024-05-23T14:59:45Z