Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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
    4 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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, 

 

First of all thank you for reaching out, secondly I have tried and it didn't work.. 

Are you able to suggest a way to get the TIME column on the left side * right column to create a third column with the total that equals 02:00:00.

 

I had a look at your links but it doesn't seem to work for what I want to achieve as it was putting the values into seconds but I just want to multiply the 2 columns by eachother to create a total. Is there a measure I could possibly write for this?

 

thanks

 

 

v-yingjl's avatar
v-yingjl
Community Support
4 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.