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.

GuntherCoppens's avatar
GuntherCoppens
Regular Visitor
6 years ago

Impressive, this is surely pointing me in the right direction.

 

Now what I do experience is that I key in for example 21pm in the GUI of the app in which I am creating the records, however PowerBI is showing this as 20pm it seems. I am in CET or UTC+1. Power BI regional settings is also set to Dutch (Belgium), so that looks to be ok. 

 

Where could that 1 hour difference be coming from?

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi GuntherCoppens ,

 

I would first check the value in the database with a simple SQL client