Impact of data types in DAX arithmetical calculations
ฝัง
- เผยแพร่เมื่อ 10 ต.ค. 2024
- How the right choice of data type and DAX code makes a significant difference in precision and performance because of internal conversions.
Article and download: sql.bi/851741?...
How to learn DAX: www.sqlbi.com/...
The definitive guide to DAX: www.sqlbi.com/...
"Level of Wrongness" is going to be my band name.
Love your channel so insightful, can you guys make a topic about “exceeded the available resources” error? This is a constant issue i run into in my reports and I don’t know what causes them or how to solve it.
Very interesting and insightful, as always.
love it Alberto.. as always
Very very interesting...granular analysis. Thanks!!!
Very interesting as always. So what if you have banking deposit data for hundreds of millions of customers (with daily transactions) and you are required to be accurate to the penny for all of them. How do you address that within Power BI?
You should use the Currency (Fixed Decimal Number) data type. However, it represents numbers up to 922,337,203,685,477.5807 - it's definitely an issue for certain currencies.
Nice Video. What happens performancewise, when you store the calculated USD value as Decimal instead of Fixed Decimal number?
Not much, you use a floating point instead of an integer, but the performance difference is negligible for the data type itself - you should look at data type conversions involved, which could be more expensive.
Great video!
I am curious about the software you are using on your mouse to mark the screen while presenting. Which one is it?
ZoomIt: learn.microsoft.com/en-us/sysinternals/downloads/zoomit
Thank you @@SQLBI
Who stores rates in row context. Even if it changes over time i prefer to have own table just for that and compute figures when there's a need.
It's an example to show the issue in arithmetical calculations, it's not meant to be a best practice for data modeling in this specific case.
@@SQLBI I know, but had to point that out as your audience represent many skill levels and I bet some people will take this as saint practice. :)