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 ProdigySame issue even with columns.
v-gizhi-msft
Community Support
Community SupportHi,
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
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.