Understanding apply semantics for window functions in DAX

  Рет қаралды 6,131

SQLBI

SQLBI

2 ай бұрын

Apply semantics is a new way of computing table expressions when multiple rows are selected in DAX window functions.
Article and download: sql.bi/836012?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

Пікірлер: 10
@VictorHugo-bd3bf
@VictorHugo-bd3bf 2 ай бұрын
I had to watch it two times to understand. Thanks so much, Alberto. As usual, the content is amazing.
@AhmedCherif-mt5lb
@AhmedCherif-mt5lb 2 ай бұрын
You are wonderful Mr Alberto, greetings from Tunisia🤩
@wilsonman8661
@wilsonman8661 2 ай бұрын
"I don't expect people to use this as a feature because it's actually uselessly complicated." This is my main takeaway! Thanks for another video. :D
@nazimscr
@nazimscr 2 ай бұрын
Congratulations on 100k subscribers, 🎉🎉🎉
@nonoobott8602
@nonoobott8602 2 ай бұрын
Very insightful video as usual. Thanks for sharing
@gurvindersingharora5301
@gurvindersingharora5301 Ай бұрын
Hello Sir, When to combine ALL function with Calculate + Filter function in DAX ? Please make a video of it 🙏 ❤
@davidoj519
@davidoj519 Ай бұрын
Wow, i repeated the video 4 or 5 times to understand and i have questions yet xD
@sarajvo2010
@sarajvo2010 Ай бұрын
Is appy semantic available only in DAX, relaing to windows functions?
@SQLBI
@SQLBI Ай бұрын
Yes!
@tareksalha
@tareksalha Ай бұрын
I never understood, why people started with window functions in dax… You can also achieve the same results with ordinary functions that do not preserve order (presumably due to clean data modeling 😉)
Introducing window functions in DAX
40:58
SQLBI
Рет қаралды 41 М.
When to use KEEPFILTERS over iterators
18:56
SQLBI
Рет қаралды 47 М.
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 17 МЛН
마시멜로우로 체감되는 요즘 물가
00:20
진영민yeongmin
Рет қаралды 31 МЛН
تجربة أغرب توصيلة شحن ضد القطع تماما
00:56
صدام العزي
Рет қаралды 57 МЛН
STOP Watching Coding Tutorials Right Now! My LEARNING FRAMEWORK
12:19
Harkirat Singh
Рет қаралды 241 М.
Understanding context transition
18:25
SQLBI
Рет қаралды 65 М.
Database vs Data Warehouse vs Data Lake | What is the Difference?
5:22
Alex The Analyst
Рет қаралды 747 М.
Optimizing time intelligence in DirectQuery
18:09
SQLBI
Рет қаралды 5 М.
Optimizing nested iterators in DAX
17:31
SQLBI
Рет қаралды 20 М.
ML Engineering is Not What You Think - ML jobs Explained
13:23
Boris Meinardus
Рет қаралды 91 М.
Bidirectional relationships and ambiguity
14:02
SQLBI
Рет қаралды 100 М.
Optimizing callbacks in a SUMX iterator
14:10
SQLBI
Рет қаралды 6 М.
1$ vs 500$ ВИРТУАЛЬНАЯ РЕАЛЬНОСТЬ !
23:20
GoldenBurst
Рет қаралды 1,8 МЛН
😱Хакер взломал зашифрованный ноутбук.
0:54
Последний Оплот Безопасности
Рет қаралды 968 М.
Что не так с раскладушками? #samsung #fold
0:42
Не шарю!
Рет қаралды 212 М.