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

Download File From Daniil's Blog
Posted on March 15, 2022 and filed under Power BI, DAX, Topics & Discussion.

Creating a Heatmap Chart Combo Using Deneb - with Daniel Marsh-Patrick

Daniel Marsh-Patrick joins me once again to walk through creating an awesome Heatmap and chart combo visual using the Deneb bespoke visual creator he developed for Power B!

Deneb is a Power BI visual that exposes these languages and lets you bind data from your model to them. We'll spend some time exploring the tool, showing you how to get started, and creating some simple examples.

If you like the visual please leave a review on AppSource as it helps support Daniel and the development of Deneb!

GUEST BIO πŸ‘€

Daniel Marsh-Patrick joins me once again to walk through creating an awesome Heatmap and chart combo visual using the Deneb bespoke visual creator he developed for Power B!

Deneb is a Power BI visual that exposes these languages and lets you bind data from your model to them. We'll spend some time exploring the tool, showing you how to get started, and creating some simple examples.

RELATED CONTENT πŸ”—

Buy Daniel a Coffee
Deneb AppSource
Daniel's Website
Daniel's Twitter
Deneb Visual Builder

Download Report From The Blog Files Page
Posted on March 8, 2022 and filed under Custom Visuals, External Tools.

[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

Download File From Daniil's Blog
Posted on March 1, 2022 and filed under Power BI, DAX, Topics & Discussion.