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: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Re: Automate Allocation of Amounts Across Months Using Power Query

05-23-2024 07:59 AM

Amardeep100115
Post Prodigy
654 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,552 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
654 Views
0