Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.