The time has come: in 2026, 𝘂𝘀𝗶𝗻𝗴 𝗔𝗜 𝘁𝗼 𝘄𝗿𝗶𝘁𝗲 𝗗𝗔𝗫 𝗵𝗮𝘀 𝘀𝘁𝗮𝗿𝘁𝗲𝗱 𝘁𝗼 𝗯𝗲 𝗲𝗳𝗳𝗲𝗰𝘁𝗶𝘃𝗲. We also created three new video courses that should not become obsolete in two weeks! 𝗔𝗜 𝗳𝗼𝗿 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜: 𝗜𝗻𝘁𝗿𝗼 (𝗳𝗿𝗲𝗲!) 𝗗𝗔𝗫 𝘄𝗶𝘁𝗵 𝗔𝗜: 𝗘𝘀𝘀𝗲𝗻𝘁𝗶𝗮𝗹𝘀 𝗗𝗔𝗫 𝘄𝗶𝘁𝗵 𝗔𝗜: 𝗦𝗰𝗲𝗻𝗮𝗿𝗶𝗼𝘀 We have a page dedicated to AI for Power BI and DAX, where you can also find the link to these courses: sqlbi.com/ai/?aff=twitter I wrote a long post to recap what has changed between 2023 and 2026, and trying to answer many questions I expect to receive: sqlbi.com/blog/marco/2026/09… I am looking forward to receiving all types of comments! 🙂

Microsoft is retiring its Whiteboard app on September 14. Here is what we drew instead: free, open source, and native to Windows 11.

Hints from a book from the future: “Honestly, it would be better to be a good data modeler and a mediocre DAX author than a DAX guru but a poor data modeler. Therefore, if data modeling is not your cup of tea, roll up your sleeves and start learning it. Maybe during the pauses, while reading this book: you will attain two great goals at once.”

The 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗶𝗻𝗴 𝗗𝗔𝗫 book (aka 𝗧𝗵𝗲 𝗕𝗿𝗶𝗰𝗸, as it is 800+ pages) is now 𝗮𝘃𝗮𝗶𝗹𝗮𝗯𝗹𝗲: - Paperback (Black & White) - Hardcover (Color) - eBook (PDF, Kindle, ePub) 𝗥𝗲𝗮𝗱 𝗺𝗼𝗿𝗲: sqlbi.com/articles/the-optim… 𝗢𝗿𝗱𝗲𝗿 𝗼𝗻𝗹𝗶𝗻𝗲: sqlbi.com/books/optimizing-d…

𝗗𝗶𝗿𝗲𝗰𝘁 𝗟𝗮𝗸𝗲 𝘃𝘀. 𝗜𝗺𝗽𝗼𝗿𝘁 𝗺𝗼𝗱𝗲 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 What is the right choice between Direct Lake and Import mode in Power BI? #powerbi #vertipaq #directlake #import sqlbi.com/blog/marco/2024/04…

The 𝘃𝗶𝘀𝘂𝗮𝗹 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗼𝗻𝘀 in #powerbi introduced a new concept: the 𝘃𝗶𝘀𝘂𝗮𝗹 𝗰𝗼𝗻𝘁𝗲𝘅𝘁. This article+video introduces EXPAND and COLLAPSE, two functions to navigate the visual context. #powerbi #visualcalcs sqlbi.com/articles/introduci…

I will speak at SqlBits 2024 in Farnborough and at the Microsoft Fabric Community Conference in Las Vegas! #sqlbits #fabricconf

I am glad to announce that @kurtbuhler has started to work with us at SQLBI. The video describes the most difficult part of the job. 😎 Read more: sqlbi.com/blog/marco/2024/03…

This article+video from @kurtbuhler describes the different approaches to format your #dax measures in #powerbi semantic models using format custom and dynamic format strings. sqlbi.com/articles/improving…

Short, sad story. Once upon a time, there was a 𝙡𝙖𝙯𝙮 data modeler. Their semantic model did not work. End of the story. Credits: @FerrariAlberto #powerbi #datamodeling

This article+video shows how to compute ratios when row-level security hides some of the data, and you need a percentage that includes the hidden rows in the comparison. #powerbi #dax sqlbi.com/articles/computing…

The DirectQuery over SQL section of the Optimizing DAX video course is now available! More than five additional hours of lectures, assuming you know how to optimize SQL afterward. #dax #optimizingdax #powerbi Read more: sqlbi.com/blog/marco/2023/11…

Inside Calculation Groups is available. It is a deep dive into calculation groups in #dax: multiple calculation groups, precedence, sideways recursion, composite models, and several DAX Patterns as a calculation group. For #powerbi and #ssas #tabular. sqlbi.com/blog/marco/2023/06…

After years in “stealth mode,” we’re excited to introduce DAX Optimizer. Dive deeper here: daxoptimizer.com/blog/introd… DAX Optimizer is a tool – delivered as a service – that helps identify potential bottlenecks and suggests impactful solutions and priorities. You still write the code, but it is like you have a mentor on the side teaching you best practices, focusing on the most impactful area of your measures. Spend your time where it matters, getting immediate improvements. For example, you may have 200 measures, many of which have similar coding practice issues: Where to start? DAX Optimizer guides you to the more important measures, which could be the ones that are more frequently used by other measures and not necessarily those that directly appear on any report. Now that we are out of stealth mode, we have much to say: how it works, how it preserves sensitive data, how it works for teams and individual developers, and share the plans to improve it over time. We will do that in the coming weeks. Where are we now? Our beta program is live, initial users are onboarded, and the waitlist is growing. We’re gradually rolling out invitation codes in the coming weeks. The service is functional, the UI for a single developer is polished, and the documentation is shaping up. While we work towards our public release, we’ll be actively seeking your feedback to refine DAX Optimizer. We won’t be rolling out a major marketing campaign yet, as we’re committed to perfecting the tool. Do not expect videos or articles from us until public release. That said, beta participants are welcome to share their experiences, as we do not require any NDA. Articles, videos, with the good and the bad – all are fair game. We believe in transparency! Join us in shaping the future of coding with DAX Optimizer. Your code, optimized. daxoptimizer.com/

daxoptimizer.com Waitlist only! #daxoptimizer #powerbi