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

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/highlight… 📽️ youtu.be/l0DETT4QR_Y?si=cFm0…

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

I was fortunate to meet the #DAX grandmaster @FerrariAlberto in person, the experience was incredibly gratifying and amazing. 🤩 I am immensely grateful for the opportunities provided by @SQLMissSunshine , @oengels and @_Tillmann . You guys are amazing! #gratitude #grateful

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…

Are you ready for SQLBi-ts Unveiled?😉 The #SQLBI team - @marcorus and @FerrariAlberto - 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!📅

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! :)

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

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

I think we should all get together and purchase this for @FerrariAlberto's birthday.