• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 15. Power Query Techniques > Adding Calculated Fields to Select Queries

Adding Calculated Fields to Select Queries

One of the rules of data normalization is that you should not include the results of calculations in a database. You can output the results of calculations by building those calculations into queries, and you can display the results of the calculations on forms and reports by making the query the foundation for a form or report. You can also add controls to forms and reports that contain the calculations you need. In certain cases, this can improve performance.

You can include in the columns of a query result the result of any valid expression, including the result of a user-defined function. This makes queries extremely powerful. For example, you could enter the following expression:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint