Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I want to remove after my data transformation every blank columns so I have to entpivot and pivot it to remove them automatically. I do this step at the end because the amount of needed columns fluctuate between the data so I dont want to have columns which I dont need.
However, when I pivoted the columns again to the initial state, every column is declared as a decimal, even when I declared some columns as whole numbers before. So is there a disadvantage if I declare whole numbers as decimals? Are there some things I have to pay attention when I do my calculations and visuals?
Solved! Go to Solution.
@Clout , refer this blog- explained in details - https://www.sqlbi.com/articles/choosing-numeric-data-types-in-dax/
@Clout , In the case of decimal, there can be an approximation that can happen in few cases. unless most needed you should convert whole number to decimal
Whole number operations are faster the decimal. Whole number can be used for key columns for fatser retrival
Okay so the main difference is the speed of calculation?
@Clout , refer this blog- explained in details - https://www.sqlbi.com/articles/choosing-numeric-data-types-in-dax/
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |