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.

v-yinliw-msft's avatar
v-yinliw-msft
Community Support
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.