Forum Discussion
pawelj795
Post Prodigy
Post ProdigyMultiply Minutes times Quantity
Hi, I have two measures like below. Now, I want to multiply them, but when I do that, the results are decimal numbers. How to change them to Minutes/Hours?
pawelj795Post Prodigy
Post Prodigyamitchandak
The problem is that I have indirect relationship between these two tables.
That's why I must use measures instead of columns.
amitchandak
Super User
Super UserYou can use
sumx(Table,hour(Table[Time])*60 + minute(Table[Time]))
But mutiplcation need to done on a common row context . Refer
You may have use summarize or values
- pawelj795
amitchandak
Okay I get it, thanks.
But is there any way to display hours/minutes/seconds in measure as time format like below column?