Power BI Tutor

DAX is the native language of Power Pivot for Excel, Power BI Desktop and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power Pivot for Excel, Power BI Desktop and at Analysis Services developers that want to learn and master the DAX language. The goal of this  three-day , classroom course is for the expert trainer to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios. All the attendees will receive a copy of the book,  The Definitive Guide to DAX - 2nd edition . Topics DAX Basics Table Functions Evaluation Contexts Filter and Row Context Evaluation Contexts and Relationships CALCULATE Context transition Iterators Time Intelligence Calculations DAX as a Query Language Advanced Table Functions Advanced Evaluation Context Understanding Cross filters Data lineage Advanced Relationship Handling Physical Relationships Weak Relationship...

As excited as we are to ship features and performance improvements, we are equally excited to unlock foundational capabilities for our customers. Large enterprises that leverage Power BI Premium tend to be global and subsequently multilingual. Over the years, we’ve made investments to enable multilingual business intelligence environments for our customers. As part of this journey, we shipped  metadata translations , to translate the names of tables, columns, measures, and hierarchies in Power BI Premium. This first step has allowed BI pros to design and build models in Power BI  supported languages . Today, we are happy to announce support for the DAX UserCulture function in Power BI Premium. Combined with the field parameters feature, customers can create reports that natively translate table data to the locale defined by the viewer’s preferences in the Power BI service. Although this support is limited to Power BI Premium (for architectural reasons), we do hope to support c...

So you’ve been working with DAX in Power BI but either can’t quite complete the calculations needed or maybe you just want to expand your knowledge and utilize more capabilities of DAX to bring your reports to the next level – this is the course for you! In this in-depth DAX Bootcamp, all of your DAX knowledge will be enhanced to a point where you will have the tools to create any kind of calculation that is possible within the DAX language. You will also be learning about best practices, performance tuning, and much more! Please note, you get   extra 25% off   with your Unlimited On-Demand Learning membership! If you are a member, please contact   training@pragmaticworks.com   to complete registration. Prerequisites It is recommended that you have taken an Introduction to Power BI course first System Requirements Access to Power BI Access to DAX Studio Access to Vertipaq Analyzer (an Excel Power Pivot Workbook) Course Outline: Module 01 – Understanding and Defi...

We are very excited to announce the public preview of a new REST API to query datasets in Power BI by using Data Analysis Expressions (DAX). Among other things, this new DAX REST API helps to address customer feedback concerning programmatic access to the data in a dataset (for example, the idea   REST API access to READ datasets   with almost 500 votes by the time of this announcement). The new DAX REST API avoids dependencies on Analysis Services client libraries, requires no connection to   XMLA endpoints , and works in Power BI Premium as well as in Power BI shared capacity. In short, there are many good reasons for BI solution developers to evaluate this REST API during the public preview period. One of the greatest advantages of a REST API to query datasets is that you can use this REST API in practically any modern development environment on any platform, including low-code no-code Power Apps, Power Automate, and Logic Apps, JavaScript-based languages, PowerShell, ...

Date: June 17, 2021  |  Time: 10:00 AM - 11:00 AM ET For anyone using Power BI, it’s necessary to learn at least some DAX (Data Analysis Expressions). DAX is both the query language of Power BI as well as the language used to extend the data model. In this webinar, we’ll give you an introduction into DAX from the ground up.  We’ll talk about what DAX is, why you need it, and what it can do. We’ll cover topics such as Evaluation Context, CALCULATE, Time Intelligence, and others. And like our monthly Power BI Office Hours sessions, we’ll leave time for your specific questions and use cases. Upon completion of this workshop attendees will: DAX Introduction and Basic Syntax Calculated Tables, Columns, and Measures Evaluation Context CALCULATE Time Intelligence This session is intended for Power BI and Excel users who are novices or beginners with DAX. The goal is to give users a basic understanding of DAX.  Register : https://www.bluegranite.com/webinar-intro-to-dax

Boot Camp Details So you’ve been working with DAX in Power BI but either can’t quite complete the calculations needed or maybe you just want to expand your knowledge and utilize more capabilities of DAX to bring your reports to the next level – this is the course for you! In this in-depth DAX Bootcamp, all of your DAX knowledge will be enhanced to a point where you will have the tools to create any kind of calculation that is possible within the DAX language. You will also be learning about best practices, performance tuning, and much more! Prerequisites It is recommended that you have taken an Introduction to Power BI course first System Requirements Access to Power BI Access to DAX Studio Access to Vertipaq Analyzer (an Excel Power Pivot Workbook) Course Outline: Module 01 – Understanding and Defining Relationships Module 02 – DAX Fundamentals Module 03 – Creating Calculated Columns Module 04 – Navigation Functions Module 05 – Conditional and Logical Functions Module 06 –...

Shortcut Action ALT + Click Insert cursor in DAX Editor ALT + Down Arrow key Move line down in DAX Editor ALT + ENTER New line starting from first of line in DAX Editor (no indent) ALT + I Restart intelligence ALT + SHIFT + A To comment / uncomment (toggle) a portion of code ALT + SHIFT + Down Arrow key Copy line down in DAX Editor ALT + SHIFT + F10 Move focus to ‘Visual’ menu ALT + SHIFT + F11 Show data ALT + SHIFT + Right Arrow key Select nearest word and expand selection in DAX Editor ALT + SHIFT + Up Arrow key Copy line up in DAX Editor ALT + Up Arrow key Move line up in DAX Editor CTRL + ALT + Down Arrow key Enter multiple lines of code at once in DAX Editor CTRL + ALT + Up Arrow key Enter multiple lines of code at once in DAX Editor CTRL + C Copy ...