Graph recurring data from a single input

pencekj

New Member
Joined
Jul 16, 2021
Messages
11
Office Version
  1. 365
Platform
  1. Windows
I am pretty new to Power BI so sorry if this is a stupid question, but I can't seem to find an answer with my Googling.

I have a dataset that quantifies how much money we have saved customers by certain initiatives. In it there is a column with a date when the savings started and a separate column with the savings amount. These savings are recurring month over month and we count them towards our ROI with the customer for 12 months. So my question is how can I make a graph in Power BI that shows this, when all I have is the 1st month and the amount?

For example, a savings that was input 3 months ago would show in the bar chart total on each of the 3 months even though it is just 1 line item in the data. A savings that was input 15 months ago would show for 12 months, and then would need to fall off after that.

Does that make sense what I'm asking? I'm stuck on this one.

Thanks!
 

Attachments

  • 1668201935631.png
    1668201935631.png
    2.6 KB · Views: 23
  • 1668202838547.png
    1668202838547.png
    16.9 KB · Views: 26

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Forum statistics

Threads
1,223,516
Messages
6,172,778
Members
452,477
Latest member
DigDug2024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top