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.
#2- Insert line above : (Ctrl + Shift + Enter)
Using Ctrl + Shift + Enter you can add one new line just above your current line.
#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.
#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.
#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.
#8- Decrease font size – (Ctrl + – key)
Using Ctrl + – key you can decrease the font size for DAX formula.
#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
#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
#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.