Could someone help with this dynamic rolling rev report?

[Coconut]

Hi there, I need to build a report that includes 2 filters, Start Date and End Date. What this report does is it pulls all the records that are between those 2 dates and display montly revenues. So for example, if I apply filter Start Date of Oct 1 2020 and End date Feb 2 2021 I would expect to see data in the below format. Note that the Month is dynamic base on the filter Start and End date and the monthly revenue is just the Rev divided by the number of months between the start and end date.

Title	Start Date	End Date	Revenue	Oct 2020	Nov 2020	Dec 2020	Jan 2021	Feb 2021
Item 1	Nov 1 2020	Jan 20 2021	1000	$0	$333.33	$333.33	$333.33	$0
Item 2	Jan1 2021	Jan 20 2021	10	$0	$0	$0	$10	$0
etc...

Any help would be appreciated, Thanks in advance!

[v-xuding-msft]

Hi @Coconut ，

If you think the video that Fowmy suggested is helpful, please accept it as solution. You also could share your own solution. Others will benefit from this thread. 

[Fowmy]

@Coconut 

Please refer to this article with video: https://excelfort.com/allocate-amount-monthly-excel-powerquery/

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Coconut]

That article is for a Excel solution? is it possible to do it in Power BI only?