Forum Discussion
Resolver ICalculate Revenue Per Month between two dates
Hello
I want to visualise Revenue in a matrix based on the Revenue start date and end date. Let say I have Revenue of 100,000, which appears on the Revenue Start Date. Revenue starts in January and ends in April. I would like to have the result as below.
I have a Date Table with a In Active Relationship with the Revenue start and end dates, so the Measure needs Userrelationship in it. I have also create a measure of what will be the Monthly Revenue.
I just need to figure out how to popluate the months with this.
Thanks
| Deal | Jan | Feb | March | April |
| xyz | 25,000 | 25,000 | 25,000 | 25,000 |
6 Replies
- lbendlin
Super User
Sounds straightforward. What have you tried and where are you stuck?
JB_ATHelper III
lbendlin
I have a similar issue. I need to split the Won Opportunity Amount over the months of the Project Start and End dates. I have wokred out the monthly amount based on the project duration and have added it as a calculated column. I would like to have a similar visual above, where the monthy amount populates each month of the duration of the project and shows the total of these months in the total section- lbendlin
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
