DAX Optimization Examples

Join DAX Expert, Alberto Ferrari, as he answers the question how do you optimize a DAX expression?

In this session, we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.

As you will see, most optimizations are the direct application of best practices, but the session has the additional takeaway of understanding what kind of performance you should expect from your formulas, and the improvement you might expect from learning how to optimize the model and the code.

This video was recorded during the Calgary Power Platform User Group on May 13, 2020.

Watch the April Meeting.

Download the presentation and pbix file.

Alberto Ferrari Social Profiles

Music: https://www.bensound.com

Join the Community

Become a member of the Calgary Power Platform User Group Community site and never miss a meeting!

View more from the Calgary Power Platform User Group

7 Worst Power BI Mistakes and How to Avoid Them with Andrej Lapajne

Posted In

Power BI Video

Tagged

DAX Optimizations Power BI

Renata Kalsbeek

Renata Kalsbeek is a Marketing Coordinator of Iteration Insights, a tech-enabled, data analytics solutions provider located here in Calgary, Alberta. Renata graduated from Ryerson University with a Bachelor of Commerce, where she completed a double major in Marketing and Economics within 3 years. She is passionate about marketing strategy and planning and has developed an interest in leveraging marketing automation to run a lean marketing team. Outside of work, Renata loves rock climbing and exploring the beautiful scenery of Banff National Park. With a drive to climb to the top of any mountain, she brings the same mentality to her work; striving to master all avenues of marketing.