I think we should all get together and purchase this for Alberto Ferrari's birthday.

How to manage the LINESTX function results in #dax to compute linear regression. Because LINEST and LINESTX return more than one value, you must handle a table result. #powerbi sqlbi.com/articles/imple…

daxoptimizer.com Waitlist only! #daxoptimizer #powerbi

After years in “stealth mode,” we’re excited to introduce DAX Optimizer. Dive deeper here: daxoptimizer.com/blog/introduci… DAX Optimizer is a tool – delivered as a service – that helps identify potential bottlenecks and suggests impactful solutions and priorities. You still write the

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/202…

Obtaining a straight line with an arrow pointing left to right in the diagram view of Power BI Desktop is insanely hard. Next time you see a figure like this, appreciate the effort! :)

Are you ready for SQLBi-ts Unveiled?😉 The #SQLBI team - Marco Russo and Alberto Ferrari - are taking to the stage to officially announce #SQLBits2024!🔍 Join us LIVE on your desired platform, links below!🔗 3PM EU, 2PM UK, and 9AM East Coast THURSDAY 14TH SEPTEMBER!📅

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/202…

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/compu…

I was fortunate to meet the #DAX grandmaster Alberto Ferrari in person, the experience was incredibly gratifying and amazing. 🤩 I am immensely grateful for the opportunities provided by Gabi Münster [she/her] , Oliver Engels and Tillmann Eitelberg . You guys are amazing! #gratitude #grateful

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

I am glad to announce that Kurt Buhler 🇨🇦 has started to work with us at SQLBI. The video describes the most difficult part of the job. 😎 Read more: sqlbi.com/blog/marco/202…

This article+video from Kurt Buhler 🇨🇦 describes the different approaches to format your #dax measures in #powerbi semantic models using format custom and dynamic format strings. sqlbi.com/articles/impro…

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

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/intro…

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

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

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,

Learn how to highlight a single data point among a distribution in #PowerBI; no custom visuals required. Bonus if you like D&D, cause we're analyzing the statistics of monsters. It's summer after all, let's have fun with it. 📝 sqlbi.com/articles/highl… 📽️ youtu.be/l0DETT4QR_Y?si…

Every single screenshot... DAX is soooo simple, compared to aligning a relationship!