Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm having trouble with SUMX or SUM. It appears both deliver wrong (but same) result when I sum 4 columns in the same table. I believe it's related to commas in my numbers. You can see sample of the columns I'm Summing below:
https://docs.google.com/spreadsheets/d/1oum6QkO6MgzApr2rsGgv5zg6VVCeNN1SU8CaNBlvPdg/edit?usp=sharing
My measure with SUMX and SUM deliver the same result, see them below:
Solved! Go to Solution.
Hi, @Anonymous
I have tested with your data and formula have, they work fine.
Regarding to commas, it is important to know that Power BI cannot read decimal commas, you need to change your commas to decimal point.
Paul
Hi, @Anonymous
I have tested with your data and formula have, they work fine.
Regarding to commas, it is important to know that Power BI cannot read decimal commas, you need to change your commas to decimal point.
Paul
Thank @V-pazhen-msft , I'll keep that in mind when working with my data sources.
Appreciate your time and help!
Ivan