Clicky

30 Valuable Power BI DAX Shortcuts To Quadruple Your Efficiency

how-to Sep 23, 2023
30 Valuable Power BI DAX Shortcuts

For newbies at DAX, or even if you've been using it for awhile, sometimes you find yourself thinking "there has to be a better way to do this".

If you're new to code-like editors, the navigation can feel clunky. 

This list of Power BI DAX Shortcuts can carve dog-years off of your time in Power BI. 

The best way to learn these is to try one or two of them every time you open Power BI. 

Practice is the key. Put away your mouse for a few minutes and see if you can navigate with just your keyboard. 

 

Basic Navigation 

  1. Ctrl + N: Create a new measure or calculated column.

  2. Ctrl + O: Open an existing DAX formula.

  3. Ctrl + S: Save changes to the current DAX formula.

  4. Ctrl + C: Copy selected DAX code.

  5. Ctrl + X: Cut selected DAX code.

  6. Ctrl + V: Paste copied or cut DAX code.

  7. Ctrl + Z: Undo the last action.

  8. Ctrl + Y: Redo the last undone action.

  9. Tab: Indent the selected code block.

  10. Shift + Tab: Outdent the selected code block.

 

Formula Editing 

  1. F2: Edit the selected DAX formula.

  2. Enter: Confirm changes in the DAX formula.

  3. Esc: Cancel editing or close the formula bar.

  4. Ctrl + Enter: Apply changes and keep the formula bar open.

  5. Ctrl + Shift + Enter: Create a new line in the formula bar.

  6. Alt + Enter: Start a new line within a DAX formula.

  7. Ctrl + Space: Autocomplete the function or column name.

  8. Ctrl + Shift + Space: Autocomplete the entire formula.

  9. Ctrl + A: Select all DAX code in the current formula.

  10. Ctrl + F: Open the Find and Replace dialog for DAX code.

 

Function Assistance 

  1. Ctrl + Shift + A: Open the function arguments dialog.

  2. Ctrl + Shift + U: Convert a selected column or table to uppercase.

  3. Ctrl + Shift + L: Convert a selected column or table to lowercase.

  4. Ctrl + Shift + P: Convert a selected column or table to proper case.

 

Query Execution 

  1. Ctrl + E: Evaluate a DAX formula or measure in the formula bar.

 

Query Navigation 

  1. Ctrl + Up Arrow: Move to the previous function or line.

  2. Ctrl + Down Arrow: Move to the next function or line.

 

Advanced Techniques 

  1. Ctrl + Shift + T: Create a new table in the Data Model.

  2. Ctrl + Shift + M: Open the M formula editor for Power Query.

  3. Ctrl + Shift + L: Open the Measure Grid in Power BI Desktop.

 

Conclusion

If you're needing to increase efficiency, these Power BI DAX keyboard shortcuts are a sure-fire way to do that. 

Practice them. It's an overlooked area to unlock productivity and make your life easier. 

Download My Free Guidebook

The 3-Step Plan for Getting Started With PowerBI

Learn the best way I've helped large and small companies adopt the best analytics tool you've ever seen. In this FREE guide, I'll show you my complete startup strategy for Power BI.

We hate SPAM. We will never sell your information, for any reason.