[vc_row][vc_column][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Learning about shortcuts is an integral part of mastering any program, and they come naturally as users get accustomed to using them. If you’re a regular reader of our blog, you might have noticed that Microsoft Power BI is one of the most popular programs at DevScope. We have a consultancy, and a development team specialized in Power BI, so Data Analysis Expressions (DAX) is used quite frequently around these parts.[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]We asked many members of our team for their favorite DAX shortcut when writing it in Power BI Desktop, and listed them here to help you boost your productivity:[/vc_column_text][vc_custom_heading heading_semantic=”h3″ text_size=”h3″ text_weight=”font-weight-bold” el_class=”mb-adapt-3 mt-adapt-3″]
The basics:
[/vc_custom_heading][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Go to line…: Ctrl + G[/vc_column_text][vc_single_image media=”6408″ el_class=”mb-adapt-3 mt-adapt-3″][/vc_single_image][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Select an entire line: Ctrl + I, regardless of where the cursor is[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Undo the last cursor operation: Ctrl + U[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Cut a line (empty selection): Ctrl + X[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Insert a new line above: Ctrl + Shift + Enter[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Jump to a matching bracket: Ctrl + Shift + \[/vc_column_text][vc_single_image media=”6409″ el_class=”mb-adapt-3 mt-adapt-3″][/vc_single_image][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Go to the start of your code: Ctrl + Home[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Go to the end of your code: Ctrl + End[/vc_column_text][vc_custom_heading heading_semantic=”h3″ text_size=”h3″ text_weight=”font-weight-bold” el_class=”mb-adapt-3 mt-adapt-3″]
The intermediate:
[/vc_custom_heading][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Scroll line up or down: Ctrl + Up Arrow key or Ctrl + Down Arrow key[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Indent right: Ctrl + ][/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Indent left: Ctrl + [[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Insert a new line, keeping indentation: Shift + Enter[/vc_column_text][vc_single_image media=”6410″ el_class=”mb-adapt-3 mt-adapt-3″][/vc_single_image][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Insert a new line, starting at the beginning: Alt + Enter[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Activate IntelliSense: Ctrl + Space[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Move the current line up or down: Alt + Up Arrow Key or Alt + Down Arrow Key[/vc_column_text][vc_custom_heading heading_semantic=”h3″ text_size=”h3″ text_weight=”font-weight-bold” el_class=”mb-adapt-3 mt-adapt-3″]
The advanced moves:
[/vc_custom_heading][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Comment multiple lines: Alt + Shift + A, Ctrl + KC or Ctrl + /[/vc_column_text][vc_single_image media=”6415″ el_class=”mb-adapt-3 mt-adapt-3″][/vc_single_image][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Uncomment multiple lines: Ctrl + KU or Ctrl + /[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Toggle Tab Move Focus: Ctrl + M[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Remove lines: highlight the lines you wish to remove and press Ctrl + Shift + K[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Find and replace some instances of a word: firstly, use Ctrl + D to highlight the current word, then keep pressing Ctrl + D to find and highlight each instance of that word. Once highlighted all instances you wish to replace, start typing to replace all at once.[/vc_column_text][vc_single_image media=”6416″ el_class=”mb-adapt-3 mt-adapt-3″][/vc_single_image][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Find and replace all instances of a word at once: firstly, press Ctrl + Shift + L to highlight all instances of a word/selection, then start typing to replace all at once.[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Copy a line: instead of Ctrl + C and Ctrl + V, you can copy the currently selected line to the one above or below it by either pressing Alt + Shift + Up Arrow Key or Alt + Shift + Down Arrow Key.[/vc_column_text][vc_single_image media=”6417″ el_class=”mb-adapt-3 mt-adapt-3″][/vc_single_image][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Expand selection: press Alt + Shift + Right Arrow Key to select the nearest word. Do it successively to expand the selection.[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]Shrink selection: press Alt + Shift + Left Arrow Key successively to shrink the selection.[/vc_column_text][vc_column_text el_class=”mb-adapt-3 mt-adapt-3″]We hope some of this can be helpful to you when writing DAX. Let us know if we overlooked a useful DAX shortcut so we can add them to the list and pass them on to our team. [/vc_column_text][vc_single_image media=”4420″ el_class=”mb-adapt-3 mt-adapt-3″ media_link=”url:https%3A%2F%2Fpowerbitiles.com%2F%3Fapp%3DPBIRobots%23utm_source%3DBlog%26utm_medium%3DBanner%26utm_campaign%3DBlog|target:_blank”][/vc_single_image][/vc_column][/vc_row]