Power BI Tutor

This Dev camp session will be led by Alex Power from the Power BI CAT team. Alex will teach you how to get started with creating custom functions to aid in the reusability of transformation patterns and how to add robust documentation to your Power Query queries. As this is a code first session, we’ll explore primitive and structured data types, implicit and explicit return values, the Power Query / M language VS Code extension and more. The information presented in this session will be applicable to all places where Power Query is found. Campers should be familiar with creating and testing queries using Power Query. Previous experience reading and writing M code in the Advanced Editor window is helpful but not required. Attendee Prerequisites : Campers should be familiar with creating and testing queries using Power Query. Previous experience reading and writing M code in the Advanced Editor window is helpful but not required. Click here !  to join us at Power BI Dev Camp on ...

 Query Editor QUERY EDITOR Action Keyboard shortcut Go to column Ctrl+G Add column from examples Ctrl+E Data Preview DATA PREVIEW Action Keyboard shortcut Copy cells/rows/columns Ctrl+C Select all cells Ctrl+A Select column Ctrl+Space When the focus is on the column header WHEN THE FOCUS IS ON THE COLUMN HEADER Action Keyboard shortcut Filter menu Alt+Down arrow key Change column type menu Ctrl+Down arrow key Move focus to column header on the left Ctrl+Left arrow key Move focus to column header on the right Ctrl+Right arrow key Select first column Home Select last column End When the focus is on the cell WHEN THE FOCUS IS ON THE CELL Action Keyboard shortcut Select first cell of the row Home Select last cell of the row End Select first cell of the column Alt+Home Select last cell of the column Alt+End Select first cell of the first row Ctrl+Home Select last cell of the last row Ctrl+End Select the cell one page up Page up Select the cell one page down Page down Editable Grid (Ente...

http:// As humans, we are   visually wired . Around 90% of the information that is sent to our brain is visual. Our brain can get a sense of a visual scene is less than 1/10 th   of a second because it can process visuals 60,000x faster than text. Within Power Query, we have reimagined query authoring, and we now provide an interface to easily create your queries and   visualize your data preparation   process using   ‘Diagram View’ . Our goal is to simplify the experience for citizen data analysts to get started, speed up the data prep process, and help quickly understand the flow of data. We are extremely excited to share with you the   general availability of the Diagram View   feature within Power Query Online (e.g. within Power BI dataflows). Enabling ‘Diagram View’ To enable this feature, select   ‘Diagram View’   within the   ‘View’   tab in the Power Query editor ribbon. Once the Diagram View is enabled, you will start to no...