Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to convert a Text data type to Time Data type ( HH:MM) ?

Hi Team,   Quick help needed please   I have created a calculated column based on a column which is in time duration ( Seconds) .    Column Name : Time Duration ( Seconds)    Sample Data :   ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

     

    You may try below measure:

    Measure =
FORMAT ( AVERAGE ( 'Major Incident'[Time] ), "HH:MM" )

    If it is not your case,I would suggest you create a new thread on forum so that more community members can see it and provide advice. Please remember to post dummy data and desired result.

     

    Regards,

    Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Cherie,

 

Thanks for your reply. I have understood the 24 hour format . I have one more thing in addition to this. 

 

Now that we have got time duration in HH:MM format for all records in table . I want to take an average out of it and show that in a Card thats available in Power BI Visuals. 

 

It is either showing First or Last Duration , but not average. Can you help me with this ?

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

 

You may try below measure:

Measure =
FORMAT ( AVERAGE ( 'Major Incident'[Time] ), "HH:MM" )

If it is not your case,I would suggest you create a new thread on forum so that more community members can see it and provide advice. Please remember to post dummy data and desired result.

 

Regards,

Cherie