Marco Russo

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 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

This article and video describe how to apply different formatting rules at each level of a hierarchy in Power BI (one rule at the year level, another at the quarter level, and another at the month level) using ISINSCOPE in a measure or ISATLEVEL in a visual calculation. #dax #powerbi sqlbi.com/articles/dynam…

𝗦𝘆𝗻𝗼𝗽𝘁𝗶𝗰 𝗗𝗲𝘀𝗶𝗴𝗻𝗲𝗿 𝟮.𝟬 𝗶𝘀 𝗻𝗼𝘄 𝗹𝗶𝘃𝗲! We completely redesigned Synoptic Designer to make it easier and faster to create custom maps for Synoptic Panel in Power BI. Start from a floor plan, technical drawing, or image. Define the areas you want to visualize, name them to match your data, and let Synoptic Panel bind them automatically. The new version includes: • A 𝗠𝗮𝗴𝗶𝗰 𝗪𝗮𝗻𝗱 that turns enclosed regions into editable areas with one click • A modern, redesigned interface • Local project saving • JSVG export with binding information Watch the video to see it in action, then create your next custom map at synoptic.design #PowerBI #DataVisualization #SynopticPanel #SynopticDesigner #OKViz

@brunolmtorres2 This is awesome. But in pure MS naming convention style, Ignorecapacityconstraintswithoutanycharge() would be more popular.

@marcorus Ignorecapacityconstraints()

It's Saturday. Name a DAX function that doesn't exist but absolutely should.  Wrong answers only. 😎 I'll start: MAKENOMISTAKES().

@prudvitheja29 Perfect!

@marcorus Ah, 😅 Okay. AskManagerForATeamParty()

@ehansalytics A no-brainer!

@marcorus OPTIMIZEDAX() of course p3adaptive.com/speed-up-your-…

@prudvitheja29 It seems helpful. Wrong answers only for today! 😂

@marcorus A measure for performance for a visual query, which returns a table of stats about the performance. Can be further explored, to find out the performance issues

@MicahDail Excellent bad idea!! 😀

@marcorus DIVIDEBYZERO – DAX Function (Math & Chaos) Description: The unsafe divide function that embraces divide-by-zero. Returns glorious infinity. Syntax: DIVIDEBYZERO ( <numerator> ) Return value: Scalar. Always inf. Example: DIVIDEBYZERO ( 69 ) = inf

@tate_bowman Winner!

@marcorus OBT()

@gavinclark66 Composable prompt functions!

@marcorus FINDCOOLINSIGHTS() , would probably need wrapping inside yours like MAKENOMISTAKES( FINDCOOLINSIGHTS(allmydata) ) 💡

@CommeYSert Legit!

@marcorus BRINGMEABEERPLEASE()

@sirpadk Top!

@marcorus SHOWCORRELATIONASCAUSATION()

If you write DAX for a living, you may be one of the few doing it at your company. So when a measure breaks at 6 pm, and you've tried everything, who do you call? These days, you ask an LLM and hope it didn't hallucinate too much. Then, you still have to validate its answer, and you’re alone. One thing that could help you is attending my in-person class. Three days in a room with other people who are also DAX person back at their company. You ask a question and get a real answer. And a few of those people stay in your contacts long after the three days are over, so the next time you're stuck, you actually have another person to call. Clearly, not at 6 pm! Here are the next SQLBI in-person classes: 𝐃𝐚𝐭𝐚 𝐌𝐨𝐝𝐞𝐥𝐢𝐧𝐠 𝐟𝐨𝐫 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 🇳🇱 Amsterdam, NL Jul 21-23 sqlbi.com/p/data-modelin… 𝐌𝐚𝐬𝐭𝐞𝐫𝐢𝐧𝐠 𝐃𝐀𝐗 𝐖𝐨𝐫𝐤𝐬𝐡𝐨𝐩 🇵🇱 Warsaw, PL, Oct 12-14 sqlbi.com/p/mastering-da… 🇨🇭 Lugano, TI, CH, Oct 27-29 sqlbi.com/p/mastering-da… 🇺🇸 Atlanta, GA, US, Nov 9-11 sqlbi.com/p/mastering-da… 🇬🇧 London, England, Nov 24-26 sqlbi.com/p/mastering-da… 🇳🇱 Amsterdam, NL, Dec 1-3 sqlbi.com/p/mastering-da…

Three years ago, we published our Generative AI guidelines at SQLBI. Now it's time to update them. Two things haven't changed. We use AI to improve productivity (ours and our readers'), and whenever we publish something technical that is AI-generated, we say so. 𝗪𝗵𝗮𝘁 𝗰𝗵𝗮𝗻𝗴𝗲𝗱 𝗶𝘀 𝗲𝘃𝗲𝗿𝘆𝘁𝗵𝗶𝗻𝗴 𝗮𝗿𝗼𝘂𝗻𝗱 𝘁𝗵𝗮𝘁. AI now handles the first pass on our subtitles and translations (and the quality is higher than what we used to get from humans alone); we use it for DAX analysis, testing, exercise preparation, and demos, with a human review before anything ships. One thing we notice almost every day: knowing DAX lets you write better prompts, the kind that keep the model from wandering off. Even if you never type the code yourself, knowing it is still an edge. One pro tip: use AI to boost your productivity, but don't become its victim. The moment you stop thinking, you become disposable. Your value is in the 5 to 10% of corrections the output still needs. With DAX, usually more than that, especially if you also want efficient code. Here's the part I'd pay attention to: Our readers are not only humans anymore. Some of them are agents. In a world where agents don't pay for their training, free access to advanced content is not a law of nature. So, do you think there are sustainable models for producing technical content moving forward? Genuinely curious where people land on this. Read the full article here: sqlbi.com/blog/marco/202…

This one hits harder when your country didn’t even qualify (like mine). Real question for those of you still in the tournament: when do you actually go back to work? The morning after your team is out, or do you quietly reopen the laptop before that?

Academic attention is all you need.

@i619619 I’ll try tomorrow!

@marcorus Depends how critical the review is I would at least get another model (e.g. In codex) do an adversarial analysis

Should I trust a technical review produced by Fable 5 just because it seems perfectly reasonable to me? (Trust is hard - it seems too complacent...)

You normally see Synoptic Panel behind a sales map. This one shows a hospital's bed occupancy in real time on a tablet. Every bed shows the color of whoever's in it and goes gray when it frees up. Staff sign in and read the data straight from the source as it changes. This is one of the few times DirectQuery earns its place: the data is tiny, and it moves by the minute. Power BI handles security and access, so there's no custom app to maintain. The demo data is fabricated, but the hospital that requested it is real. Watch the full video now: youtu.be/SPE7-aRmpMY?si… Try Synoptic Panel: okviz.com/synoptic-panel/

In this article+video, we implement a DAX user-defined function that removes filter-keep column filters from a calendar, using REMOVEFILTERS as the return value of the function. #dax #calendar #daxudf #powerbi sqlbi.com/articles/using…