Skip to main content

A short blog post, but one that can save you a lot of time.

Shortcut 1: Add/delete comments

Did you know that you can put text in a comment (or delete the comment) by selecting one or more lines, and then clicking CTRL+/ ?

Select the lines you want to insert in comment.

Dax functions

Press CTRL+/

The selected text is inserted in comment.

PS: You can also use the shortcuts CTRL+K+C and CTRL+K+U, but you will then have to learn two different shortcuts.

Shortcut 2: Changing values

In the following code, suppose you want to change the name of (and the references to) the variable _PY to __NrOfOrdersPY.


Most people will change all instances one by one. But you can also do this all at once:

Click on the variable you want to rename.

Click on CTRL+F2

Now you can change each instance of that variable at the same time. In the example below, you are now changing the text in 3 places at the same time. And this doesn’t only apply to variables; you can also apply it to the names of columns, tables and even functions.

Other shortcuts

Another shortcut that I often use is CTRL+SHIFT+ENTER. This shortcut key will add an extra blank line to the previous line. (So you won’t need to go to the beginning of the current line and press SHIFT+ENTER first)

The complete list

These are the keyboard shortcuts that I like and use often. If you are a fan of keyboard shortcuts, take a look at the full list on Microsoft’s site:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-keyboard-shortcuts#dax-editor

Would you like to learn more about DAX functions? Contact us via saleslearning@xylos.com for a no-obligation quote for one of our Power BI training courses.

Or subscribe to our Power BI day on Tuesday 25 october 2022 !