Forum Discussion
PoweredOut
Resolver I
3 years agoCalculate 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 a...
JB_AT
Helper III
2 years agoThanks for your reply lbendlin
Here is a sample of the Opportunity table
| Revenue | StartDate | EndDate | TotalMonths | Monthly Revenue |
| 100,000 | 01/02/2024 | 31/01/2025 | 12 | 8,333 |
I would like to have a visual with the the Year and Month columns from my Date Table and the Monthly Revenue populated in the months where the Start and EndDates are valid, Date table has a one to many active relationship with the StartDate.
I ahve created a measure which populates the month, it's a running total, but it doesn't sum up in the visual
VAR MaxDate =
MAX ( 'Date'[Date] )
RETURN
CALCULATE (
SUM(Opps[MonthlyRevenue]),
KEEPFILTERS ( Opps[StartDate] <= MaxDate
&& Opps[EndDate] >= MaxDate
)
,
ALL ( 'Date')
)
Thanks in advance