Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Multiply 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?
Need Help
Tips and Tricks
pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost 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?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

pawelj795 , for correct GT you have force row context, try like

Measure = FORMAT(SUMX(Summarize('Production Standards', 'Production Standards'[Item],"_1",Sum(TSENB_CUSTINVOICETRANS[QTY]),"_2",SUM('Production Standards'[Time])),[_1]*[_2]),"HH:MM:SS")