Chart Revenue per month over time

[Pablo_B]

Hi everyone,

I'm new to Power Bi so please excuse me if this is an obvious question.

I'm trying to build a chart that has the following components to it:

1) Revenue per Month

2) Closed Date (i.e. when the deal was signed)

3) Go Live date (i.e. when the customer actually has their products installed and can use them)

4) Contracted number of months

I would like to show revenue for every month contracted (starting from the go live date), with the closed dates (Year, Quater, Month) on the Y axis and Go Live Date (Year, Quarter, Month) on the X axis.  I would like to show this amalgamated as well as for each customer.

Thank you in advance

[v-xicai]

Hi @Pablo_B ,

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.