No video

Row Context and Context Transition

  Рет қаралды 46,620

Goodly

Goodly

Күн бұрын

In this video let's explore two of tricky concepts in Power BI - Row Context and Context Transition.
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
- - - - Blog - - - -
www.goodly.co....
- - - - Download File - - - -
www.goodly.co....

Пікірлер: 187
@atanasprodatanasov9233
@atanasprodatanasov9233 3 жыл бұрын
That's the best explanation on the whole Internet! I've watched almost every single video of SQLBI, Curbal and Excelsfun... Not to mention the endless courses on Udemy... And no one, literally no one is explaining that better!
@DrK99999
@DrK99999 2 жыл бұрын
Absolutely, I second your comments. Chandeep's Goodly channel desrves more.
@Bangloreblogs
@Bangloreblogs 2 жыл бұрын
Are curbal and Excel fun even good?
@RyanReynolds89
@RyanReynolds89 2 жыл бұрын
@@DrK99999 I’m crafting some training myself. Curious, were there specific portions of this video that helped solidify your understanding?
@manojrajeevramg6318
@manojrajeevramg6318 Жыл бұрын
Absolutely @Atanasprod
@dr.vaibhavhase5979
@dr.vaibhavhase5979 Жыл бұрын
@suzannefortune4416
@suzannefortune4416 15 күн бұрын
I truly never add comments on KZfaq videos but I really have to say that this is the best explanation. I was struggling so much trying to understand the concept and you made it cristal clear. Thanks so much Chandeep !
@sayi77
@sayi77 3 жыл бұрын
Definitely deserve more subscribers. Your explanations are excellent.
@sonalijain9024
@sonalijain9024 28 күн бұрын
This video provides the best explanation I've encountered, breaking down complex concepts into clear, manageable insights. U r amazing.
@simangasimelane9626
@simangasimelane9626 2 жыл бұрын
Best explanation I have heard on the Context transition. Not only did you demystify the Context Transition but helped me understand the Value DAX Function. Thank you so much.
@rakeshranjan7647
@rakeshranjan7647 2 жыл бұрын
Same here today i really got to know for what purpose value function is used
@jogdeepak
@jogdeepak 3 жыл бұрын
I m doing a course in Business Analytics and just finished PowerBI. This video gave me a clear understanding of the diff between and measure and a column and also whats row context, this clarity i did not get from my trainer from the institure. Hats off to Chandeep.
@arpitgupta6145
@arpitgupta6145 11 ай бұрын
Thanks buddy for explaining context transition so simply and easily, have gone through multiple blogs and videos but wasn't able to have grip, now feeling much more confident Once again thank you so much
@pravinshingadia7337
@pravinshingadia7337 2 жыл бұрын
Best description of Context Transition I have heard. Listened to loads of videos and first time I've actually understood it finally.
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Thanks.. glad you found it helpful!
@HellenofTroy897
@HellenofTroy897 2 жыл бұрын
Goodly, you have explained a really abstract concept so clearly!! I just couldn't wrap my mind around filter context, row context and context transition until your videos. They're the best on the subject.
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Glad it was helpful !
@joaorataoo
@joaorataoo 3 жыл бұрын
Excellent explanation. You were able to explain in a very simple way a complex and major DAX topic.
@cbaide100
@cbaide100 Жыл бұрын
Finally, an understandable explanation of what Context transition is. I had seen many videos, including videos from Dax gurus but did not get the meaning of this concept until I watched this video. Kudos to the Goodly channel!
@sbn4862
@sbn4862 2 жыл бұрын
I read more books about DAX, but all with unsuccessful result, I've started see your video resently, it seems to me more usefull. How mutch i paied.....steel no result PLEASE KEEP THIS METHOD ALWAYS. AND THANK YOU VERY MUTCH!!!!!!!
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Glad it was helpful!
@samranjan6241
@samranjan6241 3 жыл бұрын
Beautifully Explained Goodly...Crisp and clear
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Glad you found it helpful!
@meghasyam427
@meghasyam427 7 ай бұрын
OMG!!!! I have seen a bunch of other channel videos but I couldn't understand 1% of it. But the way you have explained graphically just made me understand it a lot easier. Absolutely amazing. I'm going to check all the videos of yours from now. Thanks a lot!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@cnieberd6072
@cnieberd6072 2 жыл бұрын
I definetly agree with the previous positive comments - very well explained. What helped me are the Powerpoint slides with visualizing the table workflow step by step. Congrats!
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Great to hear!
@Wzxxx
@Wzxxx 2 жыл бұрын
Thank You. Best explanation on whole YT and the one which REALLY explains a hard topic. I knew definition of context transition but till now I have never understood what is behind and no one really explains it in a understandable way
@felix-antoineboily-audet8261
@felix-antoineboily-audet8261 10 ай бұрын
Despite watching multiple videos on the subject, I wasn't totally grasping this concept of Context Transition. Your video helped me a lot in solidifying my understanding. Good job and thank you so much!
@shafa7668
@shafa7668 Жыл бұрын
I have been watching this for a couple of years. It didn't click. But I got it now. Thanks mate!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Great to hear Shaf!
@smartshan4u
@smartshan4u Жыл бұрын
very effectively and simply explained -ROW and CONTEXT Transition, the very essence of understanding DAX. Great thanks!
@djardar
@djardar Жыл бұрын
The only video that finally made me understand context transition! Thank you very much
@swarnadipbandyopadhyay1727
@swarnadipbandyopadhyay1727 Жыл бұрын
Sir.. This is the best explanation I have received so far on Context Transition. I have read books on DAX but this concept still eluded me. You have used those diagrams that are the best instruments to clarify what is really going on in DAX.
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Excellent Swarnadip!
@bravucod
@bravucod 3 жыл бұрын
I was having such a hard time understanding this concept but you made it extremely clear!!!!
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Thanks Daniel - I am sure you'll like this context transition video too kzfaq.info/get/bejne/prp5ZaSEzMvHd3U.html
@azizahmedkhan669
@azizahmedkhan669 Жыл бұрын
your videos are too good and easy to understand, please make a series of POWER BI videos like a step by step tutorial for any one who wish to learn POWER BI, many a times people doesnt know whether to start and they always have question whether they have learn most of the essential POWER BI topics or not, so please make video list covering all POWER BI essential topics chapter by chapter.
@abeerattia4523
@abeerattia4523 2 жыл бұрын
Thanks for this explanation , the first time i understand this topic that easy and that clear , well done
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Glad it was helpful!
@mohsenbenromdhane7643
@mohsenbenromdhane7643 3 жыл бұрын
I've watched all these Dax guru's to understand context transition but only this video was really helpful cheer bro keep moving forward
@databrainspro
@databrainspro Жыл бұрын
Best ever video! Thanks … I fully understood.😊
@hashanwijerathne1158
@hashanwijerathne1158 2 жыл бұрын
The best explanation for Context Transition...
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Thank you!
@tlee7028
@tlee7028 2 жыл бұрын
Thank you! For making a difficult concept so simple to understand with the examples and clear explanation !
@Richkotite1
@Richkotite1 9 ай бұрын
I have to agree, SQLBI, Curbal and Udemy are not at your level. Your explanations are the best. Thank you!
@maeshakib9646
@maeshakib9646 3 жыл бұрын
Honestly you deserve more subscribers and views. Respect and love from Bangladesh
@joncannaday250
@joncannaday250 2 жыл бұрын
Thank you for posting, I have your videos for career growth and Bishop Barrons' for Spiritual growth. I describe the quality of both of your presentations as "clean waters" and if I had children I would let them swim in these pools of thought. Again thank you for your knowledge and quite frankly I feel debited to both of you.
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Made my day Jon. Cheers
@ramakrishnaravula8768
@ramakrishnaravula8768 3 жыл бұрын
Thank you bro way of explanation , Please make some more videos on Dax functions and functionality
@ImranHussain-xv4se
@ImranHussain-xv4se 2 жыл бұрын
Now I understood the concept of context transition properly, thanks goodly
@bsai1070
@bsai1070 2 жыл бұрын
awesome explaination.that is the exact frequency im looking for .Fast and precise.Not wasting any time
@harneetkaursandhu7050
@harneetkaursandhu7050 2 жыл бұрын
I am able to have some clarity on this topic for the first time through this video. Excellent work done. Please keep going 👏
@charlesabboud1613
@charlesabboud1613 9 ай бұрын
What a fantastic explanation, thank you very much my friend
@tacijjola
@tacijjola Жыл бұрын
Great video. Thank you, especially for the VALUES function. That's all much clearer now. Thank you Goodly
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like it!
@marilenadonofrio9787
@marilenadonofrio9787 2 жыл бұрын
Bravo! Kudos to you, Chandeep👏👏👏👏👏
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Glad you liked it
@vijayparsai7291
@vijayparsai7291 2 жыл бұрын
Awesome Explanation this type of explanation I was search from last 6 month but here my searching end. Thank you so much @chandeep sir.
@wwpharmacist
@wwpharmacist 9 ай бұрын
Crystal clear 🎉 Thanks
@sanketchaudhari3458
@sanketchaudhari3458 Жыл бұрын
Hi Sir, Thank you for this video. this video has cleared all my doubts and I checked all videos but this detailed explanation havn't got on youtube ..... Thank you Sir. I am very late to subscribe your channel.
@waynethurman2144
@waynethurman2144 3 жыл бұрын
This guy takes the "difficult" and makes it simple. I think that is who Einstein said were the good teachers. The bad teachers can't or refuse to do such!
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Thanks Wayne, I am glad I could help!
@rajkaro6
@rajkaro6 Ай бұрын
Wonderful explanation bro 👍🏼, to be honest sqlbi are legends in DAX but there explanations of row context and context transition is not clear , it creates more complexity, after years of using DAX watching this video was ah moment as it cleared my view about row context and context transition.
@rajeevagarwal6519
@rajeevagarwal6519 2 жыл бұрын
Excellent explanation of this topic, this was something I was searching from very starting. It could not be better than this. !!!
@hashanwijerathne1158
@hashanwijerathne1158 2 жыл бұрын
Best explanation ever for Context Transition
@husnabanu4370
@husnabanu4370 3 жыл бұрын
Clear explanation i had spend 2 days seeing all different videos to understand row and filter context ...Im atleast clear now with respect to row context
@husnabanu4370
@husnabanu4370 3 жыл бұрын
Can we use ALL instead of VALUES since our aim is to give the unique products??
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
@@husnabanu4370 No because VALUES will return the unique product for the current context ALL will return the unique product overriding the current context. So they are different
@abhinavgupta7620
@abhinavgupta7620 2 жыл бұрын
Best Explanation i have ever come across..
@phorton968
@phorton968 3 жыл бұрын
Clear and concise. To the point.
@agustinpena948
@agustinpena948 3 жыл бұрын
AGREED! Best explanation by far out there. Thanks for doing this!
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Thanks a ton. Glad you liked it!
@snandhini9780
@snandhini9780 Жыл бұрын
can you please give the tips for creating better visuals. your all videos are very helpful for me and very clear to understand.
@pallavijain3957
@pallavijain3957 2 жыл бұрын
Wow... excellent explanation...that clears my confusions...thank you.. Just one question...if a create a variable for sumx sales before values function..will it work here??
@EricHartwigExcelConsulting
@EricHartwigExcelConsulting 6 ай бұрын
I love this video! It really breaks things down in a way that I can follow. I do have a question about your courses, which one would you recommend for someone to learn DAX that is geared toward Excel and not Power BI?
@GoodlyChandeep
@GoodlyChandeep 6 ай бұрын
Would recommend my combo course on DaX + M Language
@EricHartwigExcelConsulting
@EricHartwigExcelConsulting 6 ай бұрын
@@GoodlyChandeep found them! Thank you!
@gabrielegrano8204
@gabrielegrano8204 3 жыл бұрын
Best explanation about context transition!!
@user-kw7ce2mh3j
@user-kw7ce2mh3j 2 жыл бұрын
Amzing explanation. Really helped me to understand row context
@JoyOFIndia
@JoyOFIndia 2 жыл бұрын
This is Amazingly explained so well . Thanks a lot for the valuable teaching :)
@nitinat3590
@nitinat3590 2 жыл бұрын
Amazing explanation. Take a bow!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you liked it!
@udayakumarsakthivel6285
@udayakumarsakthivel6285 3 жыл бұрын
Hey bro. Thanks for such simple explanation
@CNich90
@CNich90 Жыл бұрын
Amazing explanation! Thanks
@wayneedmondson1065
@wayneedmondson1065 4 жыл бұрын
Awesome. Thanks for the clear and concise explanation. Thumbs up!!
@GoodlyChandeep
@GoodlyChandeep 4 жыл бұрын
Glad you enjoyed it!
@punchbuddies220
@punchbuddies220 Жыл бұрын
You're the best, man! Cheers
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Thanks Man!
@GodParticleZero
@GodParticleZero 3 жыл бұрын
I thought the context transition occurred because the measure [Total Sales] has an implicit calculate wrapped around it when used in an expression. Thus, it iterates through the column returned from values, converting each row to a filter, which is then applied to the [Total Sales] sales table. Kind of hard to explain, but I hope that makes sense
@PeterKontogeorgis
@PeterKontogeorgis 3 жыл бұрын
Bit late to the party, but this is a great explanation of what is usually a difficult topic for people to understand. I only recently discovered your channel and really enjoy your method of explaining things. Look forward to future content.
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Thanks Peter! Glad you enjoyed it 😊
@narendrababu2287
@narendrababu2287 3 жыл бұрын
Omg. How i didn't get this channel suggesion on PBI. awesome explanation.
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Welcome aboard!
@shoaibrehman9988
@shoaibrehman9988 4 жыл бұрын
Excellent finally first time understand this concept in deep dive. Thanks
@GoodlyChandeep
@GoodlyChandeep 4 жыл бұрын
Glad you found this helpful
@ms-rc9tx
@ms-rc9tx 2 жыл бұрын
Very well explained.
@anuragbawankar685
@anuragbawankar685 3 жыл бұрын
Thanks a lot sir ! I always get to learn from your each and every video .
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Glad it helped
@shubhamkhatri6908
@shubhamkhatri6908 3 жыл бұрын
Simply the best. Love from India❤️. Just have one question, why context transition didn't happen in sumx scenario. True champ- Chandeep
@Amitsxna-1234
@Amitsxna-1234 3 жыл бұрын
This is great!! best explanation!!
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Glad it was helpful!
@anupamabasu2392
@anupamabasu2392 2 жыл бұрын
Absolutely awesome!!! Thank you!
@ItsWithinYou
@ItsWithinYou 2 жыл бұрын
Super! Thanks for sharing!
@seamushand8439
@seamushand8439 9 ай бұрын
Great explanation
@sonamsuri3475
@sonamsuri3475 3 жыл бұрын
Insightful video indeed. Sir, referring to explanation given in this video, how do we create a measure to calculate total sales provided quantity and price columns are part of different tables. Sumx function perform calculations on the same columns of same table only.
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Hello Sonam. 1. You need to create a relationship (one to many) between 2 tables 2. Then write the following =SUMX ( SalesTable, SalesTable[Units Column] * RELATED ( ProductsTable[Price Column] ) ) The Related function is like writing VLOOKUP Refer to this video - kzfaq.info/get/bejne/bKiUobSEks6-pqs.html Hope this helps
@kunalgupta5667
@kunalgupta5667 Жыл бұрын
Keep doing this great work sir☺️
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Thank you!
@HaiderAli-vt8wn
@HaiderAli-vt8wn 3 жыл бұрын
Clear and concise...thanks
@houssamayoubi8715
@houssamayoubi8715 2 жыл бұрын
Great video, Thank you
@fealgu100
@fealgu100 2 жыл бұрын
Excellent work! As usual.
@naidupinninti7543
@naidupinninti7543 3 жыл бұрын
Very insightful. Thanks man.
@hydham9924
@hydham9924 Жыл бұрын
Amazing content. Thanks a ton.
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you liked it!
@AdnanKashemOxe
@AdnanKashemOxe 3 жыл бұрын
Excellent lessons Bro... Keep it up.. Best Wishes
@jeanescalona2587
@jeanescalona2587 2 жыл бұрын
The Best explanation ever!!! Where Can I find your DAx mastering training?
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
goodly.podia.com/power-bi-dax-course
@grahamlindsay9798
@grahamlindsay9798 2 жыл бұрын
Great explanation 👍
@GoodlyChandeep
@GoodlyChandeep 2 жыл бұрын
Glad you liked it
@SuperDarekR
@SuperDarekR 3 жыл бұрын
You'r the BEST
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Glad you found it helpful!
@pmsocho
@pmsocho Жыл бұрын
Great! Thanks!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
You're welcome!
@birendrasingh849
@birendrasingh849 6 ай бұрын
🙏 Superb...
@georgiostsichritzis2152
@georgiostsichritzis2152 2 жыл бұрын
Thank you. So actually the trick is using MAXX over the unique products to change granularity?
@bernardarhin2628
@bernardarhin2628 Жыл бұрын
My challenge with DAX and power bi in general is the inability to know whether a result displaying in a visual is correct or not. With everything happening in the background, what validation process can one carry out to know if the result is correct or not? In some instances, like what you just demonstrated, it seems obvious but in others where the figures appear to be unique, it is difficult to tell from just looking at the visual. I'm a beginner so please pardon my ignorance. I really need some guidance on this issue. Also, where can I find DAX practice questions with solutions?
@user-li7mq5hp9g
@user-li7mq5hp9g 3 жыл бұрын
Great explanation! Thank you.
@tuaantuaan2323
@tuaantuaan2323 3 жыл бұрын
thank you so much for making this video goodly man
@krishnaiyer5698
@krishnaiyer5698 2 жыл бұрын
Excellent
@LokeshKumar-yi3ln
@LokeshKumar-yi3ln 2 жыл бұрын
Great Video..
@Wzxxx
@Wzxxx Жыл бұрын
I heard today that filter function operates in row context and calculatetable in a filter context. Both output same table as a result. In the first one there is a need to use releted and && etc. Can you make a video which explain these differences?
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 4 жыл бұрын
Great Video, important concepts for DAX users to understand. I am including this video in today's Excel curation corner, and I have sent you on some $bat and $hive tips. thanks for creating awesome content.
@GoodlyChandeep
@GoodlyChandeep 4 жыл бұрын
Hey Paula, thanks for generously sharing my video. Appreciate this a lot :)
@GoodlyChandeep
@GoodlyChandeep 4 жыл бұрын
Also not sure where should I look for $bat and $hive. Let me know
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 3 жыл бұрын
​@@GoodlyChandeep you can find out about the bat tips in this video kzfaq.info/get/bejne/priZbJiqrqyroZ8.html and the hive tips, you had a problem setting up a hive account before right?
@sandeepreddy7687
@sandeepreddy7687 4 жыл бұрын
Great video and clearly explained.
@GoodlyChandeep
@GoodlyChandeep 4 жыл бұрын
Glad you liked it
@MrBrian511
@MrBrian511 4 ай бұрын
Great job! Out of curiosity, what if I want to not only display the the maximum sales but also include the product name itself?
@GoodlyChandeep
@GoodlyChandeep 4 ай бұрын
m.kzfaq.info/get/bejne/sK-em8V20cmcqIk.html
@fog2640
@fog2640 9 ай бұрын
finished watching
@aryansena7290
@aryansena7290 Жыл бұрын
Awesome video this is..
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Thank you
@swapnahkn519
@swapnahkn519 3 жыл бұрын
very nice explanation.Just subscribed.
@azizahmedkhan669
@azizahmedkhan669 Жыл бұрын
please make video tutorial on how to clear PL 300 POWER BI Certification exam, or explain what important topics are covered in this certification exam.
@surajchavan6447
@surajchavan6447 Жыл бұрын
Awesome 😎😎
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Thank you! Cheers!
@sreejanannaparaju7455
@sreejanannaparaju7455 3 жыл бұрын
Hello chandeep,we can also use RELATEDTABLE inside SUMX fun right..to convert row to row filtering from row to context
@GoodlyChandeep
@GoodlyChandeep 3 жыл бұрын
Yes that can be done on the many side of the relationship
What is Filter Context?
10:44
Goodly
Рет қаралды 26 М.
Don't make these CALCULATE Function Mistakes! ⚠️
10:09
This Dumbbell Is Impossible To Lift!
01:00
Stokes Twins
Рет қаралды 37 МЛН
When you discover a family secret
00:59
im_siowei
Рет қаралды 25 МЛН
I Took a LUNCHBAR OFF A Poster 🤯 #shorts
00:17
Wian
Рет қаралды 10 МЛН
Row Context in DAX
20:42
SQLBI
Рет қаралды 97 М.
Context Transition in Power BI and Tricky Examples
15:06
Goodly
Рет қаралды 42 М.
Understanding Row Context and Filter Context in Power BI
10:04
Pivotalstats
Рет қаралды 3,7 М.
Variables in DAX
17:08
Goodly
Рет қаралды 43 М.
Advanced Excel Data Cleaning Tricks ONLY Experts Know
13:37
Kenji Explains
Рет қаралды 23 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 101 М.
Advanced Grouping Tricks In Power Query
15:34
Goodly
Рет қаралды 23 М.
This Dumbbell Is Impossible To Lift!
01:00
Stokes Twins
Рет қаралды 37 МЛН