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: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Automate Allocation of Amounts Across Months Using Power Query

05-24-2021 03:57 AM

Super User Fowmy
Super User
1303 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,303 Views
0
Amardeep100115
Post Prodigy
Post Prodigy

‎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?

Amardeep Bhingardeve
Message 2 of 2
405 Views
0