Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Monthly trend line with average revenue between 2 dates

Hi all, 


I have the following challenge. I have a data set with contract information with a start and end date and the total revenue of the contract.

What I want to show now is a trend line of the monthly fee per contract (so x-axis average revenue p/m, and y-axis the year+month). I have already created some other metrics like average monthly fee, total number of months, etc (see example below).


The challenge I have is getting a visual that spreads the revenue of the contract over all the month in between (so for contract A in the attached example, Jan18 is 1k, Feb18 is 1k, and so on, which i can then show on a trend line).

 power bi example.PNG


Thank you for your support!


Regards, Paul 

Frequent Visitor
Frequent Visitor
Community Support
Community Support



You may drag date from a calendar table and apply virtual relationship in DAX to add an appropriate measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Sam, 


Thank you for message! Unfortunately, that doesn't seem to work. I have tried to do this, but everytime i try it only takes the start date or end date as specific date values. So it doesn't spread it between the two dates. any idea how i could solve this? 


Thank you in advance! 




Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors