Optimizing LASTNONBLANK and LASTNONBLANKVALUE calculations

  Рет қаралды 10,475

SQLBI

SQLBI

Күн бұрын

Пікірлер: 15
@gregoryoliveira8358
@gregoryoliveira8358 Жыл бұрын
This video helped me to author my first advanced semi-additive measure: warehouse amount monthly. :-) Thanks for your great material and support.
@BernatAgulloRosello
@BernatAgulloRosello 3 жыл бұрын
Still struggling to imagine different ways of getting the same result, but I am getting better only by watching your videos. For me it's definately one of the few good things this pandemic has enabled
@HeliSal700
@HeliSal700 3 жыл бұрын
The right video at the right time. I have to solve a similar challenge for my customer today. Thank you
@pedrobaltazargonzalez4281
@pedrobaltazargonzalez4281 2 жыл бұрын
You are amazing! thanks for sharing your knowledge. Un saludo desde El Salvador, Centroamerica
@lmblancoancos
@lmblancoancos 3 жыл бұрын
Thank you Alberto. Awesome!!! as all your optimizing videos
@Bharath_PBI
@Bharath_PBI 3 жыл бұрын
Very useful info. Enjoying DAX! Thank you 👍
@rdg515
@rdg515 2 жыл бұрын
Great video!
@teigenxayden
@teigenxayden 8 ай бұрын
excerllent video!
@mnowako
@mnowako 3 жыл бұрын
Again, excellent lesson. Your videos are second to none. Can you please make videos every working day? That would be awesome 👍
@santoshraghunath8133
@santoshraghunath8133 3 жыл бұрын
Hi Alberto, thanks for all the videos you make. One question out of syllables - which camera you use, it looks so good.
@SQLBI
@SQLBI 3 жыл бұрын
Read here: www.sqlbi.com/blog/alberto/2021/02/14/on-my-recording-gear/
@Fernando_Calero
@Fernando_Calero 3 жыл бұрын
I'm struggling because my Previous Date measure returns blank... I have a Calendar table with a 1:N relationship to the Sales table in order and followed exactly. 😕
@Fernando_Calero
@Fernando_Calero 3 жыл бұрын
I've got it. I was using the Sales date in the table visual instead of the dimension date.
@wisa7615
@wisa7615 3 жыл бұрын
Oke, why not use allselected on date column, because allselected removes any filter inside the query
@ashishmohan4707
@ashishmohan4707 3 жыл бұрын
Hi Alberto very useful video and very practical need everyone for every project ......very big thanks to share with us. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂 But due to my humble request can you plzz cover basic to advance level of RLS
Optimizing nested iterators in DAX
17:31
SQLBI
Рет қаралды 22 М.
Using ALLEXCEPT vs ALL VALUES
13:35
SQLBI
Рет қаралды 57 М.
So Cute 🥰 who is better?
00:15
dednahype
Рет қаралды 19 МЛН
Леон киллер и Оля Полякова 😹
00:42
Канал Смеха
Рет қаралды 4,7 МЛН
Try this prank with your friends 😂 @karina-kola
00:18
Andrey Grechka
Рет қаралды 9 МЛН
Optimizing callbacks in a SUMX iterator
14:10
SQLBI
Рет қаралды 7 М.
Propagating filters using TREATAS in DAX
19:18
SQLBI
Рет қаралды 47 М.
PL-300 (Power BI): DAX functions IF, BLANK and ISBLANK.
11:55
I Do Data
Рет қаралды 2,7 М.
Understanding context transition
18:25
SQLBI
Рет қаралды 73 М.
DAX for Power BI - MTD/YTD vs Previous Years
8:18
BI Elite
Рет қаралды 41 М.
Working below a DAX formula’s granularity
15:16
SQLBI
Рет қаралды 20 М.
Introducing window functions in DAX
40:58
SQLBI
Рет қаралды 45 М.