iiinova — where your digital self keeps evolving

Defining the right contract is a key activity for a DAX developer using AI. In this article and video, we introduce the concept of a contract through simple examples. www.sqlbi.com/articles/understandin… #dax #ai

010

Marco Russo @marcorus.bsky.social · 04/10/2026

𝗧𝗵𝗲 𝗼𝗿𝗰𝗵𝗲𝘀𝘁𝗿𝗮 𝗰𝗼𝗻𝗱𝘂𝗰𝘁𝗼𝗿 Is the world going to require more conductors than players? A reflection about AI-driven processes that goes beyond data analytics. I like orchestras. It has nothing to do with computers or with my job. ──────── marcorusso.com/writing/the-orchestr…

020

Marco Russo @marcorus.bsky.social · 03/10/2026

Depending on how you look at it, this answer could be correct 😎

110

Marco Russo @marcorus.bsky.social · 03/10/2026

For the record, a refresh reloads the data. It shouldn’t refactor anything. Would you leave an agent alone with your model for a weekend? Wrong answers only

100

Marco Russo @marcorus.bsky.social · 01/10/2026

✨ Testing DAX Measures with AI If you change a measure and want to make sure it still works in every report, this might save you some time: let the AI create the tests nobody wants to write! Watch the full video here: www.youtube.com/watch?v=qYQpl5Hjdk0

010

Marco Russo @marcorus.bsky.social · 26/09/2026

The first one goes down on its own. The second one is why we made the “DAX with AI” course. www.sqlbi.com/campaign/dax-with-ai-… How many pills are you willing to take?

222

Marco Russo @marcorus.bsky.social · 24/09/2026

It’s the same dilemma for new developers? Should they learn one or more programming languages? Hard to say. You can also dictate now. Many options. I did my journey on keyboard using those without letters. DasKeyboard if I remember well.

say.id

110

Marco Russo @marcorus.bsky.social · 23/09/2026

The time has come: in 2026, 𝘂𝘀𝗶𝗻𝗴 𝗔𝗜 𝘁𝗼 𝘄𝗿𝗶𝘁𝗲 𝗗𝗔𝗫 𝗵𝗮𝘀 𝘀𝘁𝗮𝗿𝘁𝗲𝗱 𝘁𝗼 𝗯𝗲 𝗲𝗳𝗳𝗲𝗰𝘁𝗶𝘃𝗲. I wrote a long post to recap what has changed between 2023 and 2026: www.sqlbi.com/blog/marco/2026/09/22… Watch my short video:

youtu.be

Start using DAX with AI

The time has come: in 2026, using AI to write DAX has started to be...

030

Marco Russo @marcorus.bsky.social · 22/09/2026

A simple daily average can mask complexity that isn't immediately apparent. In this article and video, we explore several edge-case scenarios to meet different requirements, using AI to speed up development. www.sqlbi.com/articles/the-hidden-c… #powerbi

021

Marco Russo @marcorus.bsky.social · 21/09/2026

I have a free online session about VertiPaq on Saturday, September 26, 10:00 UTC (11:00am GMT, 12:00pm CEST, 6:00am EST). If you think Direct Lake is the new kid in town, well, internally it's always VertiPaq after transcoding... so... no excuses! Agenda/registration at retrodata.live

060

Marco Russo @marcorus.bsky.social · 19/09/2026

I think I need to focus more on that. Thank you! 🙏

000

Marco Russo @marcorus.bsky.social · 19/09/2026

Good news, everyone. The meeting about protecting focus time was well attended. Do you need focus time to focus on your focus time? Wrong answers only!

142

Marco Russo @marcorus.bsky.social · 09/09/2026

If you teach/demo... Prepare a presentation for SQLBI Whiteboard: - Create a .wimport file with the text, code, and bitmap to include - Open it with SQLBI Whiteboard - Start the presentation, highlight and mark elements There is also an export to PDF/PPTX! whiteboard.sqlbi.com

050

Marco Russo @marcorus.bsky.social · 08/09/2026

A DAX calculation can produce good values at any level but not at the total; the issue could be the granularity. This article+video introduce four levels of granularity that should be identified before writing your DAX formula. www.sqlbi.com/articles/writing-dax-…

060

Marco Russo @marcorus.bsky.social · 04/09/2026

CTRL+V: paste DAX code F6: Format it Highlight the code and teach. Also with SQL. Interested in other languages? SQLBI Whiteboard, free, open-source. whiteboard.sqlbi.com · Microsoft Store: apps.microsoft.com/detail/9NN5N0L2T… · GitHub: github.com/sql-bi/SQLBI-Whiteboard

030

Marco Russo @marcorus.bsky.social · 02/09/2026

Do you think Direct Lake is the future? It's all about VertiPaq after transcoding! Join my free session on VertiPaq: Sept 26, 10:00 UTC. No excuses! Register now: retrodata.live #VertiPaq

052

Marco Russo @marcorus.bsky.social · 31/08/2026

SQLBI Whiteboard can capture any running app onto the canvas: this is a live Power BI report. Freeze the frame, annotate, teach. Free, MIT-licensed, boards are local files. whiteboard.sqlbi.com

000

Marco Russo @marcorus.bsky.social · 28/08/2026

I don’t think so - but they certainly didn’t handle this communication well 🙂

010

Marco Russo @marcorus.bsky.social · 28/08/2026

Update: Microsoft postponed the retirement of the standalone Whiteboard apps — new date: 𝗢𝗰𝘁𝗼𝗯𝗲𝗿 𝟭𝟲, 𝟮𝟬𝟮𝟲. After that date: installed apps "display a retirement experience instead of opening." So: one more month. The free, open-source replacement isn't going anywhere:

whiteboard.sqlbi.com

SQLBI Whiteboard

A native Windows 11 whiteboard for teaching DAX, SQL, and data modeling, with pen, touch, and live application capture.

161

Marco Russo @marcorus.bsky.social · 28/08/2026

"The standalone Windows, iOS, and Android apps retire on September 14, 2026." — Microsoft's own migration page, today. The replacement is already on the Microsoft Store: free, open source, native Windows 11. whiteboard.sqlbi.com

030

Marco Russo @marcorus.bsky.social · 15/08/2026

During an eclipse, something small hides something enormous for a few minutes, and nobody can see the big thing. Happens to your data model every other day, right?

020

Marco Russo @marcorus.bsky.social · 11/08/2026

This article+video shows how to leverage AI to refactor existing DAX code, remove duplicated parts, and centralize the common code in user-defined functions. #dax #powerbi #udf www.sqlbi.com/articles/creating-dax…

041

Marco Russo @marcorus.bsky.social · 10/08/2026

The new default visual style in Power BI does not have alternate colors, but you can get it back! #powerbi www.sqlbi.com/blog/marco/2026/08/10…

040

Marco Russo @marcorus.bsky.social · 29/07/2026

DAX user-defined functions (UDFs) are now available on Azure Analysis Services. Do you think there are missing articles about using DAX UDFs? Should I create one about Analysis Services (Azure and on-prem)? www.sqlbi.com/dax-user-defined-func… *SOTA = state of the art

sqlbi.com

DAX user-defined functions (UDF) - SQLBI

This page groups articles, videos, tools, and additional material for using DAX user-defined functions (UDFs). Articles List of articles about DAX user-defi

000

Marco Russo @marcorus.bsky.social · 28/07/2026

Visual calculations can either improve or degrade the performance of a report. In this article + video, we show how to ensure visual calculations have a positive impact on performance. #dax #visualcalc #powerbi www.sqlbi.com/articles/analyzing-th…

020

Marco Russo @marcorus.bsky.social · 25/07/2026

Everyone is talking about movie formats right now, and IMAX gets the votes because it shows the bigger picture. Should your reports get an IMAX format too?

030

Marco Russo @marcorus.bsky.social · 14/07/2026

This article and video describe how to apply different formatting rules at each level of a hierarchy in Power BI using ISINSCOPE in a measure or ISATLEVEL in a visual calculation. #dax #powerbi www.sqlbi.com/articles/dynamic-form…

041

Marco Russo @marcorus.bsky.social · 13/07/2026

𝗦𝘆𝗻𝗼𝗽𝘁𝗶𝗰 𝗗𝗲𝘀𝗶𝗴𝗻𝗲𝗿 𝟮.𝟬 𝗶𝘀 𝗻𝗼𝘄 𝗹𝗶𝘃𝗲! We completely redesigned it to make it easier and faster to create custom maps for Synoptic Panel in Power BI. Watch the video to see it in action, then create your next custom map at synoptic.design #PowerBI #DataVisualization #SynopticPanel

000

Marco Russo @marcorus.bsky.social · 11/07/2026

ISGOODDAX would be better IMHO - it would include judgment 🤣

110

Marco Russo @marcorus.bsky.social · 11/07/2026

This is a too useful function to qualify as a wrong one! 🙂

110

Marco Russo @marcorus.bsky.social · 11/07/2026

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

540

Marco Russo @marcorus.bsky.social · 30/06/2026

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 www.sqlbi.com/articles/using-remove…

031

Marco Russo @marcorus.bsky.social · 29/06/2026

Going online tomorrow. Post removed, will publish again tomorrow 🙂 thank you!

100

Marco Russo @marcorus.bsky.social · 29/06/2026

100

Marco Russo @marcorus.bsky.social · 16/06/2026

This article/video describes how to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller. #dax #powerbi #udf www.sqlbi.com/articles/optional-par…

010

Marco Russo @marcorus.bsky.social · 06/06/2026

We introduced comics to the SQLBI Newsletter almost one year ago. Lately, they are starting to realize they are not real. How do you know you are not in a simulation? Wrong answers only! 😎

430

Marco Russo @marcorus.bsky.social · 02/06/2026

ALL, ALLSELECTED, ALLEXCEPT, and REMOVEFILTERS: There are several DAX functions to remove filters from the filter context. This article + video clarifies what to use depending on the requirements. #dax #powerbi www.sqlbi.com/articles/all-vs-allse…

000