The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
For the simple table with one column:
Column1 1 2 3 4
PRODUCT function returns different results, depending on number format in Column1:
Whole Number:
Currency:
and only with standard Decimal format it works as prescribed:
This measure:
=CALCULATE(PRODUCT(Test[Column1]),ALL(Test))
and its PRODUCTX companion also return wrong results with whole or currency number formats:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.