Forum Discussion
Projected Revenue Based on Average Per Day
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- NMC201 year agoHelper I
Hello,
Below is some sample data. [Days Since Install] and [Days Until Removal] are fields calculated based on today's date.
I have a measure which works out a [Cumulative Revenue To Date].
I have a measure which works out [Average Revenue per Day] ([Total Revenue] / [Days Since Install])
I have a measure which works out [Projected Revenue] ([Average Revenue per Day] * [Total Days of Install])
On a chart, I have managed to show [Cumulative Revenue To Date] so an incrementally increasing line chart (see below).
With the above measures, I can see a final [Projected Revenue] for the duration of an installation of a project. However, what I would like to do (if possible) is see this broken down by day and show it on the [Cumulative Revenue To Date] chart.
I assume I need to divide [Projected Revenue] by [Days Since Install] then produce a cumulative measure for this. I'm just not sure if that will work on the chart below.
I've done a very crude drawing of what I would like to do below. I can do the orange bit - it's the blue I'm struggling with.
I have managed to get the [Installation Date] as my minimum on the X axis and [Removal Date] as my maximum but I am struggling in working out whether I can see [Projected Revenue] by day, beyond the actual [Cumulative Revenue To Date].
I hope this helps explain what I'm after. I really appreciate the help!
Sample Data
Date of Order Location Amount Paid Net Revenue Transaction Fees Installation Date Removal Date Days Since Install Days Until Removal Total Days of Install 01/12/2024 Project 1 3 2.76 0.24 01/12/2024 20/12/2024 14 6 20 01/12/2024 Project 1 2 1.77 0.23 01/12/2024 20/12/2024 14 6 20 02/12/2024 Project 1 3 2.75 0.25 01/12/2024 20/12/2024 14 6 20 02/12/2024 Project 1 2 1.77 0.23 01/12/2024 20/12/2024 14 6 20 03/12/2024 Project 1 3 2.75 0.25 01/12/2024 20/12/2024 14 6 20 03/12/2024 Project 1 3 2.76 0.24 01/12/2024 20/12/2024 14 6 20 04/12/2024 Project 1 2 2.76 0.24 01/12/2024 20/12/2024 14 6 20 04/12/2024 Project 1 3 2.75 0.25 01/12/2024 20/12/2024 14 6 20 05/12/2024 Project 1 2 1.76 0.24 01/12/2024 20/12/2024 14 6 20 05/12/2024 Project 1 3 2.77 0.23 01/12/2024 20/12/2024 14 6 20 06/12/2024 Project 1 2 1.75 0.25 01/12/2024 20/12/2024 14 6 20 06/12/2024 Project 2 3 2.77 0.23 06/12/2024 02/02/2025 9 44 53 07/12/2024 Project 2 3 2.75 0.25 06/12/2024 02/02/2025 9 44 53 07/12/2024 Project 1 2 1.76 0.24 01/12/2024 20/12/2024 14 6 20 08/12/2024 Project 2 3 2.76 0.24 06/12/2024 02/02/2025 9 44 53 08/12/2024 Project 2 2 1.75 0.25 06/12/2024 02/02/2025 9 44 53 09/12/2024 Project 1 3 2.76 0.24 01/12/2024 20/12/2024 14 6 20 09/12/2024 Project 2 3 2.77 0.23 06/12/2024 02/02/2025 9 44 53 10/12/2024 Project 1 3 2.75 0.25 01/12/2024 20/12/2024 14 6 20 10/12/2024 Project 1 3 2.77 0.23 01/12/2024 20/12/2024 14 6 20 11/12/2024 Project 2 2 1.75 0.25 06/12/2024 02/02/2025 9 44 53 12/12/2024 Project 1 3 2.76 0.24 01/12/2024 20/12/2024 14 6 20 12/12/2024 Project 2 3 2.76 0.24 06/12/2024 02/02/2025 9 44 53 13/12/2024 Project 2 3 2.75 0.25 06/12/2024 02/02/2025 9 44 53 14/12/2024 Project 2 3 2.75 0.25 06/12/2024 02/02/2025 9 44 53