We added 5 new exercises in the calculation groups section of the Mastering DAX video course, and 48 new videos explaining the solution for each exercise of the entire course.

All the video courses benefit from the new features introduced in the SQLBI Video Learning Platform: complete transcripts synchronized with the video, the option to highlight parts of the transcript and save them as a bookmark, new customized layout options including dark mode, and more.
You can also test drive these features by enrolling in one of our free video courses.

Import vs DirectQuery in Power BI 7:24 Alberto Ferrari

Bidirectional relationships and ambiguity 14:02 Alberto Ferrari

CALCULATE pills #10: Using TREATAS 4:18 Alberto Ferrari

The best shopping day of the year is around the corner. Don't miss our special discounts by visiting the SQLBI website on Nov 27, 2020!

	• Power BI Premium per user public preview now available The Power BI Premium per user option will be available in preview to all the Power BI tenants starting next week (November 30). We've already tried it, and it is a game-changer for small and medium companies. While in preview, you can use it for free and assign individual workspaces to a Premium capacity. Nov 11, 2020 · Microsoft
	• Power Desktop BI November 2020 release This month Power BI got a new diagram view and field list in preview. An upgrade is required in every model; you will not be able to roll back, so you want to create a copy of your PBIX file before upgrading the model in case you have any issue with the new visualization. There is also a new visual zoom slider and anomaly detection for line charts, plus many other small improvements. Nov 12, 2020 · Microsoft
	• Diagram View in Power Query You can display a Power Query transformation graphically in a diagram view! The impact of this feature deserves a new name: Visual Data Prep. This is a public preview now available only in dataflows, but we expect it to be included in Power BI Desktop later. Nov 12, 2020 · Microsoft
	• What’s new in Power Query & Dataflows – November 2020 The diagram view is only the most important of the many new features released for Power Query and Dataflows this month. The schema view is also important, but the list is so long and we don't have much space. Read the news to see the full list! Nov 12, 2020 · Microsoft
	• Tabular Editor 2.13.0 If you try Power BI Premium per user, you have to upgrade to the latest release of Tabular Editor which fully supports Power BI Premium Gen2. You also have to upgrade if you use the DAX Formatter feature: an improved API is now supported, with better performance if you use a script to format all the measures. Warning: you have to update the script too! Nov 16, 2020 · Daniel Otykier
	• Update of Tabular Editor online documentation Tabular Editor now has a full documentation that is more accessible through search engines. The quality and the quantity of this content is simply amazing. Many commercial tools don't come with that level of support! Nov 16, 2020 · Daniel Otykier
	• Visualizing Azure Analysis Services processing tasks with the Job Graph event You can now analyze where the time is being spent during a process operation thanks to the new Job Graph event type available in Azure Analysis Services. As suggested in the article, this would be a nice feature in DAX Studio, making it easy to use also for Power BI. Time will tell... Nov 15, 2020 · Chris Webb
	• Creating a Power BI solution using dataflows for aggregations This article (with a 30-minute video) shows how to create aggregations for a composite model using a dataflow. The video shows the new diagram view for both the dataflow transformation and the Power BI data model. It is a good tutorial if you are looking for a detailed step-by-step guide. Nov 19, 2020 · Andy Cutler
	• Combining calculation groups in Power BI to create powerful reports Moving a list of measures to a calculation group can be the workaround to easily get tooltips working on any measure in a matrix. This is an interesting way of using calculation groups in Power BI. Sep 2, 2020 · Kane Snyder
	• Power BI & Synapse Part 4 – Serverless SQL: How much will it cost me? This article compares nine different implementations to digest 1.3 Gb of CSV data, including a final cost comparison that really clarifies the impact of different choices. Each cost must be related to the frequency of the requests, which could vary: you import data once, you pay for each query in DirectQuery. Producing this benchmark is very time-consuming and time is money: this article is very valuable! Nov 20, 2020 · Nikola Ilic