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?
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
pawelj795Post Prodigy
Post Prodigyamitchandak
Okay I get it, thanks.
But is there any way to display hours/minutes/seconds in measure as time format like below column?