Forum Discussion
2 Significant Figures
Hi PBI Experts,
How to calculate 2 Significant Figures in Dax expressions.
prakash11440278 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Are you taking about data format in meausre/column tools
Appreciate your Kudos.
6 Replies
prakash11440278 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Are you taking about data format in meausre/column tools
Appreciate your Kudos.Hi amitchandak ,
When rounding significant figures the standard rules of rounding numbers apply, except that non-significant digits to the left of the decimal are replaced with zeros.
Example: 356 rounded to 2 significant digits is 360
In the table below 305.459 is rounded from 0 to 6 significant figures. For comparison the same number is rounded from 0 to 6 decimal places. You can see the difference between rounding for significant figures and rounding to decimal places.
Hi, struggling with the same topic, any suggestion?
Hi, struggling with the same issue, any suggestions?
Hi prakash11440278 Anonymous manutremo I've created a function in power query to round to significant figures and post it here: https://community.fabric.microsoft.com/t5/Power-Query/Round-to-Significant-Figures-using-Power-Query/m-p/3485175#M113917
let me know if you have any issue accesing or using it
