Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Automate Allocation of Amounts Across Months Using Power Query

05-24-2021 03:57 AM

Super User Fowmy
Super User
1772 Views
Fowmy
Super User
Super User

Automate Allocation of Amounts Across Months Using Power Query

‎05-24-2021 03:57 AM

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! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Labels:
Message 1 of 2
1,772 Views
0
Anonymous
Not applicable

‎05-23-2024 07:59 AM

it has monthly distributed amount and i am looking for quarterly 

i have to split mount to fiscal quarter like on this blog he has split for months 

 

how we can do this?

Message 2 of 2
874 Views
0