Summary

In this lab, you created some new Measure tables to store your calculations and organised
your fields and tables. You gained knowledge of Power BI DAX Formatting tips which will go
a line way to establishing good habits to increase the maintainability and readability of your
code.
Shortcuts in the Power BI Measures Editor provides a quick and convenient way to navigate
and edit measures efficiently. When the Measures Editor is open, you can utilise powerful
keyboard shortcuts for different actions. You can to Shift + ? to see your shortcut commands
and some common shortcuts in the Measures Editor include:

  • Ctrl+Space: Displays an IntelliSense-like list of available functions and measures,
    helping users quickly select and insert the desired functions.
  • Ctrl+Shift+F: Formats the measure expression, improving readability and
    organisation.
  • Ctrl+] or Ctrl+[: Matches parentheses or brackets, assisting with maintaining balanced
    syntax.
  • Ctrl+Shift+/: Comments out the selected portion of the measure expression, allowing
    users to temporarily exclude or explain specific sections.
  • Ctrl+Shift+L: Lists all the measures in the current table, providing an overview and
    easy navigation between measures.
  • Tab: Indents the selected line or block of code, aiding in visually organising the
    measure expression.
  • Shift+Tab: Removes the indentation from the selected line or block of code, adjusting
    the formatting as needed.
    These shortcuts save time and enhance productivity by reducing the need to manually type
    out functions, improving code readability, and simplifying navigation within the Measures
    Editor. There are actually a lot of shortcuts in Power BI Desktop that not only apply to the
    Measures Editor but a lot of other places like when on a visual and more – see
    https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-keyboardshortcuts for a comprehensive list of all shortcuts.
    By becoming familiar with these shortcuts and incorporating them into their workflow, users
    can streamline measure creation and modification, boosting efficiency and effectiveness in
    their Power BI development tasks