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?

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

Same issue even with columns.

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,

     

    It is because the measure total depends on context not the current field in visual.

    This is a classical measure total issue.

    Please try this:

    Measure =
FORMAT (
    SUMX (
        DISTINCT ( TSENB_CUSTINVOICETRANS[Item name] ),
        TSENB_CUSTINVOICETRANS[QTY] * 'Production Standards'[Time]
    ),
    "HH:MM:SS"
)

    Hope this helps.

     

    Best Regards,

    Giotto

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

      v-gizhi-msft 
      amitchandak 

      I tried both of your's solution but it still didn't work.

      In some cases the results are correct but in most cases are incorrect.