Forum Discussion

GuntherCoppens's avatar
GuntherCoppens
Regular Visitor
6 years ago
Solved

Time based progress bar using current datetime

Hi,   I am looking for a way to show progress as in a progress bar. I have a table where records are inserted and the most important fields on that table are: datetime created duration So you ...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi GuntherCoppens ,

     

    you can try this.

     

    Progress = DIVIDE(DATEDIFF('Table'[datetimecreated],NOW(),SECOND),'Table'[duration])

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support. 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi GuntherCoppens ,

     

    Please check the measure below.

    Measure = FORMAT(DATEDIFF(SELECTEDVALUE('Table'[datetimecreated]),NOW(),SECOND)/SELECTEDVALUE('Table'[duration]),"percent")

     

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

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

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi GuntherCoppens ,

 

you can try this.

 

Progress = DIVIDE(DATEDIFF('Table'[datetimecreated],NOW(),SECOND),'Table'[duration])

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.