1 min from the beginning of this session, I fell in love with your style of teaching. Well articulated. Even the dumbest of all would understand it.
@CurbalEN
2 жыл бұрын
Thanks !!!
@mohammadazadi3616
Жыл бұрын
perfect,perfect and perfect.The easiest to understand filter and row context . I had seen several tutorials on this subject before, but this video was really simple and understandable. Thanks a lot
@ramvsrk
Жыл бұрын
Hi Mohammad, can you help me on getting the data. Though i know how to import to data, i don't know where this Orders, Customers, Product tables are present.
@SaniGarba
5 жыл бұрын
Most digestible content on CONTEXT that I have come across. Thank you, Ruth. The simplicity of this context principle is the reason why it appears so complicated. Your approach demystifies DAX. Again, thank you.
@CurbalEN
5 жыл бұрын
Happy it is useful Sani! /Ruth
@Freemachains
3 жыл бұрын
OMG !!! i v been stick for the last weak trying to filter a measure with calculate function , and all it was needed is to do it by calculated column , it's 2 AM right now and i finally got what i was looking for thanks to you !
@ayobamiologun9184
5 жыл бұрын
Ruth is simply awesome with the way she doles out her knowledge. God bless you.
@CurbalEN
5 жыл бұрын
Thanks Ayobami and Happy Friday!! /Ruth
@Shib_ghosh
4 жыл бұрын
Evaluation context is the most important part of DAX and in this video you have explained the topic very nicely. The explanation is very simple and insightful.. Thank you so much for all the effort you put to create these videos since there are limited resources available on DAX.❤️❤️
@khalidrasheed7724
Жыл бұрын
beautifully explained. you are teacher by your nature.
@matthewclarke2899
4 жыл бұрын
yes, excellent teacher, clear, concise, good speed, good examples, and relaxed style
@CurbalEN
4 жыл бұрын
Thanks Matt! /Ruth
@Prasoon.Chauhan
4 жыл бұрын
The way you teach is like a mother teach her child, simply awesome 😊😊. Always ♥️ to see your videos at any time,and its 5 AM here in India 😋. Now i sleep in peace.
@CurbalEN
4 жыл бұрын
Sweet dreams 😴😴! /Ruth
@ashaoluayanfe7474
2 жыл бұрын
I love your style of teaching: fun, engaging and educating.
@CurbalEN
2 жыл бұрын
Thanks!
@hasnainhaider8191
4 жыл бұрын
This video entails the most fundamental concepts that should be part of every beginner session on DAX, measure and column. I spent last 2 days, in working a measure right, and if I had known this earlier, it would've certainly helped.
@CurbalEN
4 жыл бұрын
Glad it helped!! /Ruth
@mangaldeep9544
2 жыл бұрын
rip , rippped , ripfied ....superb 16:24 ... cut to the chase....u saved hell lotta my time
@rpv1494
2 жыл бұрын
Nice Job, very clear and your enthusiasm is affectious.
@TroyLambert
4 жыл бұрын
Coming from a business excel user's perspective - this is an easy to understand format - excellent job
@CurbalEN
4 жыл бұрын
We have the same background, so it might help ;) /Ruth
@junaidbagwan5523
4 жыл бұрын
whenever I have difficulty understanding any DAX Function, I come here. Thanks for Sharing your knowledge in such simple and understandable way!
@CurbalEN
4 жыл бұрын
Pleasure to hear :) Ruth
@techienomadiso8970
3 жыл бұрын
Ooh my God 😍🙏 By the 6th minute you've already said the clarity I was looking for 😭 Thanks a lot ❣️❣️❣️
@CurbalEN
3 жыл бұрын
🥳🥳🥳
@claurecoba11
5 жыл бұрын
The 101 Series is awesome, they are a lot of different topics that need to be understood in order to build something consistent. I haven't watched all your DAX Friday series yet (and I will..) but I think this type of videos help us to understand why things happen as they do, this is SO IMPORTANT. Also, they are many real-life situations that are very complicated to solve when you don't know which DAX formula, modeling strategy or even a simple tip are needed to point you in the right direction. A particular case that I haven't seen anywhere it's about the use of USERELATIONSHIP to filter by many date fields (that part it's out there) but no one tells you that if one of the dates has time and the other doesn't (12:00 AM by default), the USERELATIONSHIP does not work between those related columns! I can´t leave without saying that before the video was over I had to know if I could get some "Queso Cabrales" in my country.
@CurbalEN
5 жыл бұрын
First of all, thanks for the awesome review, really appreciate it :) I will continue with the DAX101 series building on concepts and adding difficulty to them, but to do it well, I need time, so it will take time until I have all of them published. Now, to the most important part of all: where do you live so I can direct you to a sales point for queso cabrales in your country 😂😂😂 /Ruth
@claurecoba11
5 жыл бұрын
@@CurbalEN Take your time to keep making great content we can wait. I'm from Uruguay!
@CurbalEN
5 жыл бұрын
Ah, Saludos!! :) /Ruth
@CurbalEN
5 жыл бұрын
Si les pides a estos a lo mejor te lo consiguen: www.nonnoantonio.com/quesos.html ;) /Ruth
@claurecoba11
5 жыл бұрын
@@CurbalEN Muchas gracias!!
@rick_.
5 жыл бұрын
Hi Ruth, thank you for walking us through this.Oddly enough, you actually made something clearer to me that you didn't really explain in detail: why adding CALCULATE to a calculated column changed SUM from using the entire column to using the value for each separate row. CALCULATE changes the row context to an additional filter for that row and then the calculation is evaluated for each row's overall filter context. (I knew about context transition but I didn't really "get" it. Now I do!)
@CurbalEN
5 жыл бұрын
You are spoiling part 3!! ;) /Ruth
@getusama
4 жыл бұрын
@@CurbalEN hi Please can I have the link where it explains this
@jianhongsong6140
2 жыл бұрын
This is known as “context transition”.
@mePrafull
Жыл бұрын
Thank you for making the DAX concepts simple
@tak0331
Жыл бұрын
Good job Ruth! Great explanation.
@poojasahasrabhojanee971
4 жыл бұрын
You have to know your function :) You are amazing Ruth... Thank You so much :) :)
@CurbalEN
4 жыл бұрын
Thank you!! /Ruth
@philipmathew6542
2 жыл бұрын
Nicely explained....simple terms. Thank you
@CurbalEN
2 жыл бұрын
:)
@mangaldeep9544
2 жыл бұрын
fantastic exlanation.......Superb !!!!
@ssma1368
4 жыл бұрын
Wow! Ruth you are a brilliant teacher❤️
@CurbalEN
4 жыл бұрын
😊 Have a great weekend! /Ruth
@deedeec102
4 жыл бұрын
I really really wish I had seen this video last year when you published it! Thank you soo much for your style and explaining from an Excel users perspective how/why it seems so different and it is also soo nice to know that I am not the only one confused! Love your explanation of the why and authenticity!
@CurbalEN
4 жыл бұрын
You are never alone when you feel confused while DAXing, be sure of that!!
@emmadkareem5247
5 жыл бұрын
You have great desire to teach others. this is great. One remark is that you have to assume a certain level of the learner. If someone can't get what a filter is then this person will never (at this moment, at least) figure an Entity Relationship Diagram. My point is each course may require a number indicating the depth and the expected background of the student, otherwise it will be impossible for someone to use the material going forward. Thanks for the great effort you take.
@CurbalEN
5 жыл бұрын
Thanks for the feedback Emmad. It is really hard to categorize the level of a topic as depending on your background and how that person learns something that for somebody else is really easy can be advance for that person, you know what I mean? I have labeled things as beginners and advance before without much success and for that reason I let you guys decide the level after you seen the video. Hope it makes sense! /Ruth
@therealcomment5622
3 жыл бұрын
Splendid explanation and humor. Awesome!
@vakfunnyfactstelugu9531
4 жыл бұрын
Awesome.. clear and in detailed explanation, I got answers for so many questions..
@CurbalEN
4 жыл бұрын
Great! Glad it helped! /Ruth
@Maurici0GP
4 жыл бұрын
Me encanta la explicación! Y debo admitir que la cara de trauma de "uy, ¿y ahora qué hice?" lo fue todo! :D jajaja
@CurbalEN
4 жыл бұрын
😂😂😂 Seguramente te llego al alma porque lo has sufrido tú también verdad? 😂😂😂 la monda! /Ruth
@joanneosborne2428
4 жыл бұрын
Thank you for explaining this so that I can finally understand. I have struggled with this for a while and I appreciate your video' so much...You are the best!❤👍😊
@CurbalEN
4 жыл бұрын
Thanks Joanne, you too!!
@rakahs5
4 жыл бұрын
Amazing video, i have been struggling with this for a while. U have made this super simple. Thanks a lot.
@CurbalEN
4 жыл бұрын
Wonderful to hear and enjoy your weekend! /Ruth
@cadurgeshagrawal
4 жыл бұрын
Superb !!! Very Nicely explained and really get lot on insights from watching your videos... Good Job !!
@saharlatifi3510
2 жыл бұрын
Well explained!👍👍 Thank you so much ❤
@CurbalEN
2 жыл бұрын
Thank you :)
@Truth-N-Lies
3 жыл бұрын
Super Teacher. Very good explanation, you made me understand concepts, which I was looking as bigginer🌹
@CurbalEN
3 жыл бұрын
Wonderful to hear!
@kebincui
3 жыл бұрын
Thanks Ruth👍
@osamaasif9601
3 жыл бұрын
Ruth, this stuff is gold. Please keep it up.
@CurbalEN
3 жыл бұрын
Will try!
@oritogunfemi1041
2 жыл бұрын
I just subscribed to this channel. I'm also activating the notification button. thanks
@CurbalEN
2 жыл бұрын
Welcome 🥳🥳
@KirillBezzubkine
4 жыл бұрын
9:33 - CALCULATE's Filter Overrides General Filter. That s why there s only ONE number for QC product
@TheAlgebraTeacherPOWERStoBI
4 жыл бұрын
Great explanation! You're a natural teacher!
@CurbalEN
4 жыл бұрын
Thanks!😊
@saravananoumabady1778
2 жыл бұрын
Filter context and row context. Key characteristics for all beginners to understand and differentiate.
@michelcesar85
5 жыл бұрын
Your videos are very clear and easy to understand, my favorite channel! Thanks for sharing knowledge! Greetings from Brazil!!!
@CurbalEN
5 жыл бұрын
Ohh, thanks!! 😊😊 o obrigada ;) /Ruth
@michelcesar85
5 жыл бұрын
@@CurbalEN Obrigada* perfect! I love!!! :D
@KirillBezzubkine
4 жыл бұрын
Lady is positive. Though some of her explanations are not very clear... it s fun to watch her
@CurbalEN
4 жыл бұрын
Lady will try to do better ;) /Ruth
@EricaDyson
5 жыл бұрын
Very nicely explained. Well done, as usual. Thanks so much.
@CurbalEN
5 жыл бұрын
Thanks Erica!! More to come on the topic :) /Ruth
@trondlk
3 жыл бұрын
Hi, I don't find all those fields in Northwind database. I downloaded Northwind from inside Access 2016, made a local copy on PC, and imported all tables into Power BI. But there's no fields like your at Sales or Product. Why so different?
@aakuthotaharibabu8244
Жыл бұрын
Thank you for the great content. But please share the whole screen when executing some actions while using tools because i want to replicate the same.
@alanhernandez7201
3 жыл бұрын
Hello Ruth, the hidden ALL function that you mentioned removes the filter of "Queso Cabrales", it removes the product names that don't belong to Queso Cabrales ? am i right? thantk you!
@nicolehamilton8983
4 жыл бұрын
Thank you for making this so easy to understand!!!
@CurbalEN
4 жыл бұрын
🥳 /Ruth
@jasonwoodward5501
5 жыл бұрын
A joy to watch. Thank you.
@CurbalEN
5 жыл бұрын
Wonderful! /Ruth
@nonoobott8602
4 жыл бұрын
This is so brilliant and insightful. I have better understanding of the row and filter context 👍
@CurbalEN
4 жыл бұрын
Yey! /Ruth
@stefass85
3 жыл бұрын
Thnak you very much!
@sudherkumar4292
5 жыл бұрын
Wonderful... trying to get this since long time.... Great clarity given... Thanks a lot for your help.🤝🤝🤝🤝🤝🤝
@CurbalEN
5 жыл бұрын
Awesome! We will go through this in more detail in future videos :) /Ruth
@zvlspm9421
4 жыл бұрын
Aahhh! I finally understood the difference. Thank you! :)
@CurbalEN
4 жыл бұрын
😀😀😀 Excellent! /Ruth
@andrecavasotero6234
5 жыл бұрын
After hearing so much about the queso cabrales I will not give up the opportunity to taste it next time I´m near Asturias.
@CurbalEN
5 жыл бұрын
😂😂😂 it is outstanding, I promise! Otherwise I will refund you ;) /Ruth
@y1jadhav
2 жыл бұрын
Hi Curbal, I have stuck in DAX. It will be great you help me out. I have data like below in single table Data source Amount TDS 100 ODS 200 TDS 100 UDM 200 TDS 100 ODS 200 I have to display above data in table visual but data source value in visual will be one i.e. TDS and Amount and TDS-ODS Calc Data Source ODS Amount will be subtracted from TDS value. So my output of visual will be like below. Data source Amount TDS-ODS Calc TDS 300 100 Data source ODS row is not visible in output.
@Victor-ol1lo
5 жыл бұрын
Excellent video Ruth !! I wish I would have seen this video three years ago... :-) For me personally the context tansition part was quite confusing, next to filter and row context in the beginning.... As always - Thumbs Up !
@CurbalEN
5 жыл бұрын
Weird to say this, but me too!! I truly hope it helps beginners get a quicker start in DAX. /Ruth
@zhenweiyang6292
4 жыл бұрын
This is really excellent! Great video!
@jonaskarlsson477
2 жыл бұрын
Have little problem with filter I think i understand the new column and part of the messure but when i want to do filter i dont knot where to make it becouse when i do it i messurement, and try to use it in a table (Filter för det här visuella objektet) i get this. Aktiva = FILTER(TestTabell,TestTabell[startdate].[År] = 2019) --Or selectedvalues Uttrycket refererar till flera kolumner. Det går inte att konvertera flera kolumner till ett skalärt värde.
@jdgh86
3 жыл бұрын
excelent video thanks!! :)
@CurbalEN
3 жыл бұрын
Glad it helped :)
@sheilahart5989
5 жыл бұрын
Thanks Ruth! Happy Friday! :-)
@CurbalEN
5 жыл бұрын
Happy Friday Sheila :) /Ruth
@fguihen
4 жыл бұрын
Hi Ruth. Thank you for the fantastic resources, saved my bacon more than a few times! At 20:40 in the video, you say "sum does not do row by row, sumx does row by row". But...if i create a calculated column with SUMX(Sales,[Sales]), it still gives the total for the entire tables, exactly like SUM(Sales[Sales]). So even though SUMX is going row by row, it still does not give the intuitive answer I would expect. - In this case, is there truly a difference between SUM and SUMX? - If i put SUMX inside calculate, the answer is correct. is calculate imparting some default row context?
@sanierojas
4 жыл бұрын
So enlightening!! Keep it up & thank you so muuchh!!
@CurbalEN
4 жыл бұрын
Yey! And thank you for watching :) /Ruth
@kyiwinhtun
3 жыл бұрын
thanks! well explained!
@chengwang411
2 жыл бұрын
For a while, DAX to me is like a box of chocolate: I never know what I’m gonna get...🤣🤣. If this doesn’t work, I will try that. 🙃
@CurbalEN
2 жыл бұрын
🤣🤣
@alirezamogharabi8733
5 жыл бұрын
Very helpful, thank you so much.
@CurbalEN
5 жыл бұрын
Awesome!! More to come on future videos :) /Ruth
@oliveroshea5765
3 жыл бұрын
I think Ruth could explain quantum theory to kindergarten children!
@CurbalEN
3 жыл бұрын
😂 thanks!
@hildeksjursen4538
5 жыл бұрын
Thank You. From Norway 🤓
@CurbalEN
5 жыл бұрын
Varsågoda! /Ruth
@sandip_bettereveryday
5 жыл бұрын
So when you are wrapping a function with CALCULATE or for that matter when you are using any measure (because all measures are by default wrapped in CALCULATE) in a Calculated Column - what we see then is "Context Transition" which is transforming the row context into filter context hence each row started showing different results. Right?
@CurbalEN
5 жыл бұрын
Yes, with calculate, the function SUM is not “blind” anymore as Calculate forces it to see the rows as filters. That is how I make sense of it. I will do a video on that on the Dax 101 series. /Ruth
@sandip_bettereveryday
5 жыл бұрын
@@CurbalEN "...is not “blind” anymore as Calculate forces it to see the rows as filters" - nicely said. Picturesque!
@CurbalEN
5 жыл бұрын
My non tech language is shining here 😂😂 /Ruth
@marcobaquero6867
5 жыл бұрын
Super clear
@CurbalEN
5 жыл бұрын
It was!? Oohhhh nice 👍 I will continue going down this rabbit hole in future videos ! /Ruth
@walterben3111
4 жыл бұрын
Hola, Ruth, thank you for these video, no more videos of 101 series? I found only #1 DAX Fridays! 101 and #2 DAX Fridays! 101...
@CurbalEN
4 жыл бұрын
Not yet, but I will :) /Ruth
@walterben3111
4 жыл бұрын
@@CurbalEN ok thank you, i can wait... till tomorrow :D In my opinion the 101 serie is estremely useful, gracias
@pknytl
3 жыл бұрын
can't see your full screen, right panes are cut off
@vijaypalmanit
4 жыл бұрын
what you are explaining is totally useless, you didn't tell the reason, you simply told what it is doing.anybody can do that.
Пікірлер: 129