Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors