Lightnews — Scholar-powered news

Marco Russo @marcorus.bsky.social · 11h

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/

2

Marco Russo @marcorus.bsky.social · 6d

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

Marco Russo @marcorus.bsky.social · 6d

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 · 13d

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 · 17d

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 · 21d

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 · 24d

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 · 24d

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 · 26d

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