How to present a visual that displays a projection of a measurement over time

[Pentester]

Hello everybody.

I am doing an analysis on the quantities of water in a basin. I have a measurement that gives me the autonomy of the pool in number of days for a given date based on consumption. The pool can also be replenished with water at any time. Autonomy can therefore increase at any time.
I would like to display this autonomy on a visual in the form of a projection to know the Maximum date that the water stock can reach.

I don't know how to calculate this new measurement which will be displayed in the visual or which visual to really use.

Need help !

[Greg_Deckler]

@Pentester Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Pentester]

@Greg_Deckler, Thank you very much for this clarification. I will take this into account in my future posts.

here is a sample of my data

Date	autonomy (in Day)
2024-06-01	23
2024-06-02	46
2024-06-03	40
2024-06-04	30

Expected output from sample data

Date	autonomy (in Day)	MAX DATE
2024-06-01	23	2024-06-23
2024-06-02	46	2024-07-18
2024-06-03	40	2024-07-13
2024-06-04	30	2024-07-04

MAX DATE = DATE + autonomy

What visual can I use to represent this data?

[Anonymous]

Hi @Pentester 

Please try this measure:

Measure = MAX('Table'[Date])+MAX('Table'[autonomy (in Day)])

Add the measure into the table visual, the result is as follow:

You can change the format of the measure in this place:

Best Regards

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

[Pentester]

Thank you for your help. I was able to calculate the measurement using a DATEADD. Measure = DATEADD(TABLE[Date],[Autonomy (in day),DAY).

My problem currently is how to represent this data on a visual.

Do you have an idea to offer me?