Posts filed under Topics & Discussion

(Livestream Replay) Visual Formulas Vs DAX - Making a Case for InfoRiver - with Marco Russo as Moderator

Power BI has recently done a dedicated blog on Inforiver to highlight a new set of capabilities. So the owner of Lumel Visuals Gopal is going to discuss and debate the new architecture approach adopted by Inforiver. Marco Russo will also be a moderator in the livestream, as he’s advocated for visual level calculations with his SQLBI blog, and Inforiver delivers these new capabilities to Power BI.

Join us as we use our unique industry backgrounds to provide perspectives on how InfoRiver can be a smooth transition for Excel users to Power BI using a no-code visual-level calculation user-experience. We will also discuss how developers and business end-users can benefit from specific features such as: Visual Formulas, Excel like Formatting, Commenting, Planning, Paginated Reports, and Write-Back capabilities.

RELATED CONTENT 🔗

Microsoft InfoRiver Blog Post
InfoRiver
Lumel

SQLBI Visual Formulas Post
SQLBI
Marco's Twitter

Posted on March 25, 2022 and filed under Livestreams, Topics & Discussion, Power BI, Visualizations.

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

Posted on March 15, 2022 and filed under Power BI, DAX, Topics & Discussion.

[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

Posted on March 1, 2022 and filed under Power BI, DAX, Topics & Discussion.