Forum Discussion

mouzi4us's avatar
mouzi4us
New Member
9 years ago

How to change count time to sum time

Hi friends   I want to demonstrate the over time in coloumn chart in PBI , but when i  create the visual in PBI it counts the  Time values for different people instead of suming them .   i ve cha...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

I guess the question that I have is, how do you sum time? What is your desired output? What does something like 12:32 PM + 1:54 AM equal exactly? Sounds to me like you need to create another column or measure that calculates the differences between the times to get the duration.

mouzi4us's avatar
mouzi4us
New Member
9 years ago

indeed its time duration , i just wanted to sum work overtime so that i could use it in coloumn chart ,for example , but the solution which bhavesh told me, solved my problem completely

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi mouzi4us,

     

    It's not very clear about "sum work overtime" you mentioned, if possible would you please provide more detailed information about expected output?

     

    If you have found a valid solution to achieve your requirement, would you please share your solution so that it can help other community menbers those have similar requests.

     

    Thanks,
    Yuliana Gu