Forum Discussion
Solved
Calculation errors when using nested SUMX vs. naturalleftouterjoin
Hi, Sorry for long post but I am trying to build up my dax knowledge by really focusing on row context and iterator functions. As I was trying to replicate the virtual tables that are created when u...
Small differences add up and you're dealing with imprecise numbers - floats. That's normal.
Small differences add up and you're dealing with imprecise numbers - floats. That's normal.
Hi Daxter, thank you for the perspective and reference. Is there a way to ensure we deal with only precise numbers without floats?
You can use the currency type (4 decimal places) but if you divide one number by another you'll still be dealing with rounding.
