Forum Discussion

MartaGS_S's avatar
MartaGS_S
New Member
2 years ago

Round to Significant Figures using Power Query

Hi  Community!   I've created a custom function in power query to round to any significant figures you need. IT solves this type of issues that scientists usually face, that is explained here: 

https://study.com/learn/lesson/significant-figures-scientific-notation-overview-rules-examples.html 

These is a sample of the output:

 

here is the function: Function_final_7.txt

  1. Open power bi and click 'Transform Data'
  2. Click 'New Source' -> 'Blank query' and paste the function
  3. Rename to 'Format_to_sigFig'
  4. Click 'Add Column'-> 'Invoke Custom'-> column name as 'Fixed'-choose function column and the num as the text column and the sigfig column
  5. Click ok-> Transformation is done and you can grab the column in your visual. Close & Apply

 

5 Replies

  • It works perfectly!  This contribution will surely be an asset to all those looking for a way to correctly identify significant figures.  Thank you Marta!  😃  

  • The link the txt file doesn't seem to work.   Could you possibly send me the query text please?

  • MMMiranda's avatar
    MMMiranda
    Frequent Visitor

    Excellent, I appreciate you!  Thanks for sharing this.

  • Hi, this doesn't seem to be working for me for values less than or equal to -1