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?

You can use sumx(Table,hour(Table[Time])*60 + minute(Table[Time])) But mutiplcation need to done on a common row context . Refer https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451 You may have use summarize or values

Hi, Please try this measure:Measure = FORMAT(SUM(TSENB_CUSTINVOICETRANS[QTY])*SUM('Production Standards'[Time]),"HH:MM:SS")Hope this helps. Best Regards,Giotto

pawelj795 , New column in minute New column = hour([Time])*60 + minute([Time]) // Change data type from whole number to decimal

amitchandak The problem is that I have indirect relationship between these two tables.That's why I must use measures instead of columns.

amitchandak Okay I get it, thanks.But is there any way to display hours/minutes/seconds in measure as time format like below column?

Multiply Minutes times Quantity | Microsoft Fabric Community

11 Replies

v-gizhi-msft
Community Support
6 years ago
Hi,

Please try this measure:
Measure = FORMAT(SUM(TSENB_CUSTINVOICETRANS[QTY])*SUM('Production Standards'[Time]),"HH:MM:SS")
Hope this helps.

Best Regards,
Giotto
- pawelj795
  Post Prodigy
  6 years ago
  v-gizhi-msft
  Your solution works, thanks.
  
  But, I can't figure out issue with suming time (Total).
  Why isn't correct?
  - pawelj795
    Post Prodigy
    6 years ago
    Same issue even with columns.
amitchandak
Super User
6 years ago
pawelj795 , New column in minute

New column = hour([Time])*60 + minute([Time]) // Change data type from whole number to decimal
- pawelj795
  Post Prodigy
  6 years ago
  amitchandak
  
  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
    6 years ago
    You can use
    
    sumx(Table,hour(Table[Time])*60 + minute(Table[Time]))
    
    But mutiplcation need to done on a common row context . Refer
    
    https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
    
    You may have use summarize or values