Split Amount Across Months Using Power Query

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

Allocation Data.xlsx22 KB

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

Explore how-to guides, expert tips, and insights on Fabric Data Warehouse, featuring advice from Microsoft experts and leading community contributors. 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.

Blog Post

Split Amount Across Months Using Power Query