Forum Discussion

Lena85's avatar
Lena85
Helper I
3 years ago
Solved

Duration data type not converting in the PowerBI Desktop

Hi!   I am trying to build lag analysis. For that, I have a view with timestamps and various lags between them. I so far did two things.    -> calculated each lag into dd hh mm format using...
Need Help
  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    Hi Lena85 ,

     

    I reproduce your question.

    In the Power Query:

    In the table:

    You can change the type of the data like this:

    Then calculate the average:

    Average = FORMAT(AVERAGE('Table'[Time]),"hh:mm:ss")

    The result is:

    Hope this helps you.

    Here is my PBIX file.

     

    Best Regards,

    Community Support Team _Yinliw

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

Lena85's avatar
Lena85
Helper I
3 years ago

v-yinliw-msft 

 

Thank you for your suggestion. However when I replicate it, I get the following error:

 

Some of our lags have negative values as we calculate period from B - A, but sometimes, in our processes, the B can take place before A. I then cannot convert this to time. Is there any solution to this?