(Livestream Replay) [DAX] Window Functions & Tabular Editor 3 - with Daniel Otykier

ABSTRACT 📄

The Power BI December 2022 update included some exciting new DAX functions, that are all the buzz recently. Let’s explore these new functions using Tabular Editor 3’s DAX debugger to see what we can learn from them.

GUEST BIO 👤

Daniel is a Microsoft Data Platform MVP and CTO of Tabular Editor ApS – the company behind the tool. Tabular Editor is a popular tool for managing and editing Microsoft Power BI, Analysis Services, and Azure Analysis Services models. With a background in data analysis and business intelligence, Daniel has a strong understanding of the challenges and needs of BI professionals. He developed the Tabular Editor as a solution to streamline the process of managing and editing tabular models, and it has since become a go-to tool for many in the industry.

RELATED CONTENT 🔗

Tabular Editor Site
Daniel's Twitter
New DAX Functions (Dec ‘22 Power BI Release)

Introduction to Using URLs for Reports in Power BI!

Video by: Reid Havens

Learn how to add either dynamic or fixed URL links in Power BI. This video will review tables, matrixes, and other objects where you can add URL hyperlinks. Tune in to learn more!

(Livestream Replay) Lessons learned After Two Years With a Large Model - with Alex Dupler

ABSTRACT 📄

For the past two years, my team has been working on a premium Power BI model that has grown significantly in size, from 50 GB to over 100 GB. During this time, we have gained valuable insights and lessons that we would like to share with you. These include the importance of conducting systematic testing, determining which features and columns will have the most impact on performance, and managing the ongoing refresh of a model of this size. We hope that these tips will be helpful for those looking to optimize and improve their Power BI models.

GUEST BIO 👤

Alex Dupler is a Power BI developer and architect at Microsoft, where he currently serves as the lead Program Manager for a data warehouse platform supporting the company's advertising business. In this role, Alex is responsible for a Power BI import dataset with 90 GB of data. He is also one half of "Two Alex's," a YouTube channel that features live discussions on Power BI topics without one correct answer. Prior to joining Microsoft, Alex worked as a chemist. He is a member of the PBICAT team and has been inactive for a while.

RELATED CONTENT 🔗

Alex's LinkedIn

Guided Tour of My Office, Battle Station, and Home!

Video by: Reid Havens

I've been making videos for over three years now. With that in mind, I wanted to share a little more about myself and where I work, make videos, and live on a day-to-day basis. Tune in to get a grand tour!