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.

Anonymous's avatar
Anonymous
Not applicable
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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi GuntherCoppens ,

       

      The first thing i can thought is your data source has different time zones with Power BI.

       

      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

        Hi - It has.

         

        SQL stores in UTC. Normally a client adapts itself according to the regional settings of the operating system of the client, correct?

         

        So in the Business Central Client I key in 23pm (my regional settings are UTC+1), this gets stored in SQL as 22pm (UTC).

        Now PowerBi is also set to UTC+1, and it shows 22pm.

         

        Thoughts?