2 Significant Figures

[prakash11440278]

Hi PBI Experts,

How to calculate 2 Significant Figures in Dax expressions. 

[MartaGS_S]

Hi @prakash11440278 @Romano321 @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...

let me know if you have any issue accesing or using it

[Romano321]

sig fig calculator 

[manutremo]

Hi, struggling with the same issue, any suggestions?

[manutremo]

Hi, struggling with the same topic, any suggestion?

[amitchandak · Accepted solution]

@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.

[prakash11440278]

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.