Author | Lightnews

Marco Russo @marcorus.bsky.social · 8h

I don’t know. This should be foundational knowledge in data analytics. Would you deliver a third-normal-form session to a DBA? In theory no. In practice, it could be helpful even if it shouldn’t.

Marco Russo @marcorus.bsky.social · 11h

Me too, but it’s not always necessary and there are many data marts without a DWH with happy users. Just don’t assume you have a DWH if you have only a data mart.

1

Marco Russo @marcorus.bsky.social · 11h

I think that it’s a correct statement.
Only because you can it doesn’t mean you should, but that’s a different conversation.

1 1

Marco Russo @marcorus.bsky.social · 11h

I start to believe that one of the biggest misconceptions in data analytics is that dimensional modeling is for the data warehouse, whereas it is really for the data mart.

Someone should fix that.

2 3

Marco Russo @marcorus.bsky.social · 1d

Today you have one task: update DAX Studio to 3.4.0.

If you have a model with DAX UDFs (user-defined functions) or Calendars, here is the version that correctly handles autocompletion and VPAX export.

𝗘𝘅𝗽𝗼𝗿𝘁 𝘁𝗼 𝗣𝗮𝗿𝗾𝘂𝗲𝘁? Now you can!

https://daxstudio.org/blog/v3_4_0-release/

2 6

Marco Russo @marcorus.bsky.social · 3d

Yes please!

1

Marco Russo @marcorus.bsky.social · 4d

This article+video describes when to use VALUES in the table grouped by SUMMARIZE, also mentioning why SUMMARIZECOLUMNS does not have that option.

#powerbi #dax

https://www.sqlbi.com/articles/using-values-in-summarize/

1 4

Marco Russo @marcorus.bsky.social · 10d

And why this platform ignored my new lines to give a sense of distance between #1 and #2?
Meh.

Marco Russo @marcorus.bsky.social · 10d

Alex you should do a reality check. I cross post on many social media, and the result is simple.

LinkedIn #1 (by far)

X #2

Others (Bsky threads)

I cannot ignore the numbers given my job.

2 3

Marco Russo @marcorus.bsky.social · 17d

Yesterday at dataMinds.be I asked the audience how many experienced disk defrag.

I was talking about Delta/Parquet files in DirectLake.
>50% raised their hands.

Next time, I'll ask about index rebuild on SQL Server.

We are so back.

7

Marco Russo @marcorus.bsky.social · 21d

Spoiler: 800+ pages.

Not ready to announce the official release date yet, but the third edition of The Definitive Guide to DAX has broken the 800-page barrier.

But hey, there are many figures!

Coming soon...

1 1 11

Marco Russo @marcorus.bsky.social · 25d

I will be speaking live about UDF on Analytics Endeavors' channel on October 8 (morning in the US, late afternoon in Europe).
Set a reminder!

#dax #usd #live #powerbi

User-defined functions [UDFs] in DAX (With Marco Russo)

DESCRIPTION 📄In September 2025, Microsoft introduced a new feature in Power BI and in the DAX language: the ability to create user-defined functions (UDFs)....

www.youtube.com

1

Marco Russo @marcorus.bsky.social · 28d

I don’t like the idea. Unless you include metaprogramming in DAX with proper compiler optimizations, the result of similar features would be slow slow slow performances…

1 2

Marco Russo @marcorus.bsky.social · 28d

Simon Sabin and I sit down and chat to answer one simple question: why bother with conferences in 2026?

In the chat, we talk about meeting peers, asking real questions, and learning from battle-tested content (not vendor demos).

Watch (or just listen to) the video:
https://youtu.be/zwGDfL-B3jQ

1 6

Marco Russo @marcorus.bsky.social · Sep 25

I will be delivering a "Mastering DAX" Workshop in Lugano, Switzerland, from October 28-30, 2025.

This workshop is also near Northern Italy, France, and Southern Germany.

The workshop is in English.

For more details, visit: https://www.sqlbi.com/p/mastering-dax-workshop-lugano-oct-28-30-2025/

1 1

Marco Russo @marcorus.bsky.social · Sep 20

Watch a 30-minute chat with Jay recorded at FabCon25 Europe this week.
@jaypowerbi.sky.social is the product manager of DAX.

We talk about the new features just released: User-defined functions (UDFs) and Calendar-based time intelligence.

#dax #fabconeurope25

DAX UDFs and Calendar-based time intelligence: A chat with Jay

Here is a chat with Jeroen (Jay) ter Heerdt, the product manager for DAX, talking about the new features released today: User-defined functions (UDFs) and Ca...

youtu.be

2 7

Marco Russo @marcorus.bsky.social · Sep 18

Or should already work. Click on bugs and report the error thanks!

Marco Russo @marcorus.bsky.social · Sep 18

Yep - also check out daxlib.org/package/DaxL...

DAX Lib

daxlib.org

1