how to put the percentage time advance

[CLCastroEn]

Hello everyone!

I'm looking for whether it's possible to percentage the time advance, just as you can in an EXCEL. That is, define a start date and an end date. then by putting a current day that calculates the percentage of progress.

if possible, please tell me.

Thanks a lot

[amitchandak]

@CLCastroEn , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[CLCastroEn]

@amitchandak

what I need is something like, example:

start date September 25

end date November 5

current progress : (calculate percentage of progress to this day September 29)

[Sumanth_23 · Accepted solution]

Hello @CLCastroEn - Please find the steps below to calculate the same:

1. Created calculated column "Duration"

Duration: VALUE('Date-Complete'[End Date] - 'Full-Date'[Start Date])

2. Column created "%age Complete"

%age Elapsed • IF ( TODAY() > 'Date-Complete'[Start Date], (VALUE(TODAY() - 'Date-Complete'[Start Date]) / 'Date-Complete'[Duración]), 0)

The above will allocate 0% for tasks with a future start date

Please mark the post as a solution and provide a 👍 if my comment helped resolve your issue. Thank you!