MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved!

Download files:

In this video learn about how different DAX Data Types can affect multiplication and division results and yield different answers depending on the order of the multiplication or division. This apparently violates the Commutative Property of Multiplication.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

[ljubicar]

The decimal is sure the safest option! I wouldn't guess the data type could be a reason for the difference in a million years! Thanks for sharing!

[katerina]

Thank you Mike, great video as always, have a great day

[wayneedmondson]

Hi Mike.. GREAT video on this topic. Super solutions.. triple the fun! Going to get some more popcorn and watch this one again! Thumbs up!!

[MalinaC]

Wow, it is so important to use proper data type, great exaple. Thanks, Mike!

[GeertDelmulle]

Dang, until 1 minute ago I used to be “precise” in my data type assigning.
From now on it’s ‘decimal’ all the way until I reach the measure level.
BTW: this remark only applies in the “currency vs. decimal” department.
Thanks, Mike!

[SyedMuzammilMahasanShahi]

This is so awesome. Thanks Mike for this amazing video.

[DIGITAL_COOKING]

Awesome! Mike, great video, and I agree with Greet Delmulle about the usage of currency

[joelngige]

Nice insights into how data types affects calculations. Thanks

[wayneedmondson]

Hi Mike.. thanks for the great video and exposing the issue of data type and order of use in calculation. Kind of a booby trap hiding in plain sight. Thanks for sharing your wisdom. Thumbs up!

[ismailismaili]

thank you so so much for letting us pay attention to this issue.

[jeffkasavan]

Mike, thanks for the information. You make a valid "(decimal) point". :) :)

[masterof]

Thank you Mike - this one is important. I didn't know that will cause the results to be calculated differently. What is the benefit of using the Currency data type? In order to keep all the calculation precisely, should I use Decimal data type in all columns with numbers?

[johnborg]

That was great and interesting. Thanks Mike :)

[ndjanardhan]

Thanks you sir, for great tips about decimal

[HachiAdachi]

I have been under the notion that the use of currency data type would result in reduction in data size, so I have been quick to use the data type especially when working with a large dataset (usually in PQ). Now you make me wonder if the benefit of smaller data size (and maybe some performance improvement) is worth the cost of potential inaccuracy...

[sumardjo]

thanks information
very clear
thanks

[davidpellatt]

Hi Mike, To be honest I nearly always upload my data to Power Query and set the data types there before adding the data to the data Model. I then set the data type only within my DAX Measures. Regards.

[simfinso]

If I am making payments I will use Decimal & If I am Receiving money i will use currency.

[mohamedchakroun]

In this situation i stocks all data as a decimal :-)

[gentlephir]

Hope CDW will be >= WDC always, due to rounding up in C