Blog Post

Power BI Community Blog
2 MIN READ

Split Amount Across Months Using Power Query

Fowmy's avatar
Fowmy
Super User
5 years ago
In this article, we will look at how to solve an allocation issue where you need to deal with start and end dates falling within different dates in months. For Con-01 in the table below, the amou...
Updated 5 years ago
Version 11.0
how to
tips & tricks
Fowmy's avatar
Super User
I’m a Microsoft-certified BI professional with a solid background in finance, accounting, and data analytics. My main focus is on Power BI and Microsoft Fabric development, where I work on building BI solutions, consulting, and corporate training. I enjoy helping others develop their skills in data analytics and stay active in community forums to keep up with the latest trends and best practices in the field.
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
danmuscalu's avatar
danmuscalu
New Member
4 years ago

Hi Fowmy ,

 

This logic is insanely useful, however I managed to find a flaw: if the start date and end date are both within the same month, and they are not the first and last day of the month, the calculation fDay is wrong. Try adding to your Allocation Data excel file a row with:

- Start 4/7/2022

- End 4/9/2022

 

The calculation returns 24.

As I am not very experienced with M-language, can you assist with a fix for that, if possible?