Tabular Editor 3: [DAX] Debugger Walkthrough in Tabular Editor 3! - with Daniel Otykier

It is no secret that DAX is a relatively complex language which is difficult to master. Most data model developers have probably experienced a situation, where the DAX code did not return the expected result. In this situation, it is helpful to break down the code, variable by variable and function call by function call, to better understand what is going on.

Until now, this "breakdown" of the code was a tedious and time consuming task, which often involved capturing DAX queries executed by client tools, in order to break them down and execute smaller pieces of the queries in DAX Studio or SQL Server Management Studio.

Tabular Editor 3 introduces the concept of the DAX debugger, which is a tool that makes the process of stepping into the DAX code of your model, much, much easier! At a conceptual level, the debugger is similar to traditional IDE debuggers, such as the one found in Visual Studio when developing C# applications.

GUEST BIO 👤

Daniel is a Microsoft Data Platform MVP and CTO of Tabular Editor ApS – the company behind the tool.

RELATED CONTENT 🔗

DAX Debugger
Tabular Editor 3
Daniel's LinkedIn
Daniel's Twitter

[DAX] Anti-Patterns Episode Five: Removing FILTERs (with Daniil Maslyuk)

A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns! This episode will focus on ways to remove filters, understanding filter context and context transition!

GUEST BIO 👤

Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.

RELATED CONTENT 🔗

Daniil's Blog
Daniil's Twitter
Daniil's LinkedIn

[DAX] Anti-Patterns Episode Four: FORMAT() Function (with Daniil Maslyuk)

A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns! This episode will focus on Time Intelligence considerations and the FORMAT() function.

GUEST BIO 👤

Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.

RELATED CONTENT 🔗

Daniil's Blog
Daniil's Twitter
Daniil's LinkedIn

(Livestream Replay) Effective use of Bookmarks and Buttons - with Ben Ferry (Power BI Guy)

Creating a report in Power BI should always include a stage of design that considers appropriate functionality for the end users. Though data transformation, modelling, and calculations are of course vital steps, failure to consider functionality can often, especially in the initial roll-out of Power BI within an organization, hinder user acceptance, or at the very least, overshadow the good work you have done preparing the data. The use of buttons and bookmarks can be a key element in your report preparation.

Bookmarks are a simple concept, but their value lies in their adaptability and often in the imagination of the report designer. This presentation aims to show how buttons and bookmarks can be leveraged to create sleek functionality, not only adding useful elements within your reports, but also giving you many other options as to how your data can be visualized. From absolutely essential buttons which should grace all reports, to niche bookmarks which serve as a sneaky workaround, the purpose of the presentation is to show how buttons and bookmarks, though sometimes tricky to set up, can make your life easier, but more importantly, help you create a report which does the data justice.

GUEST BIO 👤

Ben is Senior Data Analyst for online and highstreet opticians in Germany. Working with Power BI since 2017, he is one of the lucky few who can count his job as his hobby. Ben’s main pleasures in Power BI come from exploring and defeating APIs with Power Query, finding new tricks to achieve interesting reports and spreading the good word of Power BI.

RELATED CONTENT 🔗

Power BI Guy: YouTube
Power BI Guy: Twitter