Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Summing time values in a table

Hi all,   I am relatively new to Power BI and need help with the following: I have a dataset in Excel that shows me why a machine was malfunctioning. For each malfunction, I have the reason for ma...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi,  Anonymous 

    You need to  create a measure to replace you original column field as below:

     

    Measure_Duration = SUM('Table'[Duration])

     

    Then change the format of measure as below:

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi,  Anonymous 

You need to  create a measure to replace you original column field as below:

 

Measure_Duration = SUM('Table'[Duration])

 

Then change the format of measure as below:

Best Regards,
Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks a lot for your solution, I managed to fix it with your help!