Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiply a time count

Hi All,    I am new to PBI and I need some support, I am trying to multiply the values sitting on top of the bar graphs by the time values at the bottom of the graph.  The values is a count ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    You can try this measure to get the result but actually text value could not be used in the bar chart singlly.

    Total Time =
CONVERT (
    CONVERT (
        CONVERT ( CONVERT ( SELECTEDVALUE ( 'Table'[Time] ), DATETIME ), DOUBLE )
            * COUNT ( 'Table'[ID] ),
        DATETIME
    ),
    STRING
)

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous I think you want something like time aggregation.
Duration
You will need to convert those to seconds, add them and essentially convert them back more or less. Look at the links below, they should get you what you need.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92