Home » DAX » DAX shortcut keys in Power BI Desktop

DAX shortcut keys in Power BI Desktop

DAX shortcut keys

Did you know DAX formula shortcut keys? In this post you will know some important DAX editor shortcut keys.

These 12 shortcut keys helps you lot and make your life easier when you working with DAX editor, so let’s get started-

#1 – Insert a new line below : (Shift+ enter)

To using Shift+ enter key you can move to the new line of code or you can say add new line below.

DAX insert new line

DAX insert new line



#2- Insert line above : (Ctrl + Shift + Enter)

Using Ctrl + Shift + Enter you can add one new line just above your current line.

DAX insert line above

DAX insert line above

#3- Select current line- (Ctrl + i)

Using this you can select current line, click on line which you want to select then press Ctrl + I.

DAX select current line

DAX select current line



#4- Comment a line – (Ctrl + K + C)

You can comment multiline DAX code to using these keys, select lines which you want to comment then press Ctrl + K+ C together.

DAX comment multiline

DAX comment multiline

#5-  Uncomment a line – (Ctrl + K + U)

If you want to uncomment multiline DAX code you can use Ctrl + K + U.

#6- Single line comment – (- -) and (//)

For single line comment you can use double hyphen(– –) or double forward slash(//) just before line which you want to comment.

DAX Shortcuts =
CALCULATE(
SUM('Global-Superstore'[Sales]),
--FILTER('Global-Superstore',
//'Global-Superstore'[Category]="Furniture")

)




#7- Increase font size – (Ctrl + + key)

Using Ctrl + + key you can increase the font size for DAX formula.

DAX Increase font Size

DAX Increase font Size

#8- Decrease font size – (Ctrl + – key)

Using Ctrl + – key you can decrease the font size for DAX formula.

DAX decrease font size

DAX decrease font size



#9- Move line Up & down – (Alt + Up arrow key) / (Alt + Down arrow key)

You can move DAX line code Up & Down, keep cursor on that line which you want to move up & down.

For Up – Alt +Up arrow key

For Down – Alt + Down arrow key

Dax move line down

Dax move line down

#10- Copy line Up & Down – (Shift + Alt +Up arrow key) / (Shift + Alt +Down arrow key)

You can copy DAX line code up and down, keep cursor on that line which you wan to copy and press up & down arrow key with Shift + Alt.

For copy line up – Shift + Alt + Up arrow key

For copy line up – Shift + Alt + Down arrow key

DAX copy line

DAX copy line



#11- Deleting a full line of code – (Ctrl + Shift + K)

Keep cursor anywhere in that line which you want to delete fully and press Ctrl + Shift + K.

#12- Go to the Start and End line of code – (Ctrl + Home ) and (Ctrl + End)

  • Ctrl + Home :  Point cursor start of the Code
  • Ctrl + End :  Point cursor end of the Code

Refer DAX post:- DAX Tutorials

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.



Leave a Reply