Multi Month Revenue Spread

Hello,

Couple of quick questions.

We currently have projects that have revenue recognised on a percent complete basis.  This can make forecasting a little tricky because we may have projects that last 6 to 12 months or projects that only last 1 month and I need to account for the revenue spread (Total project Revenue/Project Duration (Days)).  So, with that in mind:

Question 1: How can I create a date slicer that will capture projects that are active but have revenue spread out over several months?  All projects currently have a "Start" and "Finished" Date.  The issue I am running into is, if I, for example, have a project that has a Start date of 1/1/2023 and a Finished date of 8/1/2023 and set my slicer to the month of May (5/1/2023-5/31/2023) to look at forecasted revenue during that specific month, this project is filtered out because the Start/End dates falls out of range of the slicer and the revenue is not included even though there should be partial revenue spread out over this timeframe.

Question 2: Assuming I open up the date range on the slicer and a project does happen to populate that covers mulitple months, what is the best approach to tie the revenue thats been spread to individual months for visualization? For example, I have a project with revenue that is spread over two months (January which has 31 days and Feb which has 28 days). Total project is worth $10,000 and spread evenly over the number of days in each month so that January has revenue that equals 5,254.24 and Feb has revenue that equals 4,745.76.  If I am only looking at January, how do I get the table to only show 5,254.24 utilizating only the project Start and Finished dates? Is there a way to = (Total project Revenue/Project Duration (Days))*number of days that the slicer is covering?

Thanks!