I had been reading books/blogs and looking for the videos which explains context transition. So far, no one has explained better than you. Thanks a lot for this crisp clear video on context transition.
@NilayMukhopadhyay
4 ай бұрын
100%
@toirshad
3 жыл бұрын
Most tricky concept in DAX I ever felt... very well explained 👍
@ankushrathod7340
11 ай бұрын
Brother..no word to admire your explaning DAX..it is really final DAX destination...believe me it is coming from my heart....Bhai...your examples literally leave no confusion to understand DAX....I joined class and see explanation difference.........God Bless You bro...🙏🙏🙏🙏🙏🙏
@GoodlyChandeep
11 ай бұрын
Thanks Ankush :)
@JBartlett_DMU
2 жыл бұрын
I've read multiple DAX books and watched dozens of videos trying to learn context transition, and I still didn't get it, until I watched this video. You did an excellent job explaining a deceptively difficult concept. The parts where you repeated yourself actually helped a lot for me, because each time you said it the first time, I was still thinking "Ummm... I think I maybe understand it, but not sure." And then when you repeated it, I was able to compare what I thought in my head to what you were saying, and that's when it finally clicked. Some people might not like the repetition, but for me, it was absolutely necessary, and I think that might be why none of the other learning resources had managed to convey the concept successfully before now.
@aijaz4441
Жыл бұрын
To get this concept right, it is necessary to repeat it multiple time in a video. On our part, we need to repeat the video multiple times to get it right!!!
@shuddhyamukherjee2595
5 ай бұрын
One of the best videos on Context Transition, thanks for the explanation!!
@Max-wo7zp
2 жыл бұрын
The best explanation I have seen so far. Thanks!!!
@ajay22111
Жыл бұрын
Simply Amazing ,Even Some Experienced people fail to explain the way you explained.
@arpitgupta6145
Жыл бұрын
Brilliantly explained with tricky examples nitty gritty of context transition
@franckvodounnou9459
Жыл бұрын
I really loved your explainations, especially on that ticky concept of context transition. Bravo !
@GoodlyChandeep
Жыл бұрын
Glad you love them!
@HSenju03
3 ай бұрын
Best Explanation ever, thanks!
@apg360
7 ай бұрын
Chandeep, you are brilliant, fantastic. Thank you so much.
@Xploit_GG
3 жыл бұрын
Excellent Content...Thank you so much for doing this
@teukuario
Жыл бұрын
easy to understand. thanks goodly
@GoodlyChandeep
Жыл бұрын
Glad to hear that Teuku!
@CJ-jc8tn
3 жыл бұрын
Superb explanation of Context Transition. Thank you!
@kayliedoe2312
2 жыл бұрын
I'm in awe. THE BEST explanation of context transition I've encountered so far. Bought a book, watched multiple videos but still this was very tricky to understand. I'll re-watch this video when I get confused again. Cheers!
@GoodlyChandeep
2 жыл бұрын
Thanks Kaylie, glad it helped. I made another one on Context Transition here - kzitem.info/news/bejne/r6GP3auYcHtkdY4 Cheers
@KgasS
2 жыл бұрын
Nice explanation on context transition. I think for the Best Selling Day measure instead of using values function just the calendar table will also work as it always has unique values to iterate.
@GoodlyChandeep
2 жыл бұрын
Yes💯!
@bedsup
2 жыл бұрын
Beautifully explained. Thank you.
@tersit89
Жыл бұрын
Great explanation, simple examples, bravo! While watching this I understood that i had already used this concept intuitively but didn’t fully understand how it worked 😂
@sujit3375
Жыл бұрын
The only video i ever played on 0.75. And vola 70 precent of dax is done i guess
@dirkstaszak4838
3 жыл бұрын
Super explanation. One question though. Why would Giuseppe use the measure in the sumx instead of value column?
@udusegbe
3 жыл бұрын
Thanks. Clearly well explained. Specifically, the example on the mock up data was an ‘aha’ moment 😀
@kalinduSekara
3 жыл бұрын
Excellent lesson Chandeep
@Magmatic91
Жыл бұрын
very good explanation !
@hugoderek50
2 жыл бұрын
Very well explained many thanks
@GoodlyChandeep
2 жыл бұрын
Glad it was helpful!
@yekhtiari
2 жыл бұрын
Great explanation. Thanks
@sushantmore6492
2 ай бұрын
Can you please also show from which table have you used the Year and the Month columns in the table visual.
@SirTupsAlot
3 жыл бұрын
Great explanations! Thanks!
@MahadiHasan-qk5ko
2 жыл бұрын
Nicely explained. But I want to know if I want to write a measure for the maximum sales of July 2001, how to do that? I tried but it didn't work.
@raviranjansingh5527
3 жыл бұрын
Thanks sir way of explain .keep more video on dax fundamental .
@thedatapros5221
2 жыл бұрын
Hi Chandeep, great video. but i have one doubt here. when you refere some measure in calculated column like you did for total sales, logically it should not break down. because though u refer measure its a calc column and it should understand only row context and row context disable all active relationships for that table. i tried same now , but it's not breaking down. in video at 11:05 or so values are breaking down.could you please clarify this.
@TheCraigie007
3 жыл бұрын
Tricky Example Number three was beautifully explained.
@harfshortshayari3340
3 жыл бұрын
I would not say it's tricky but it is conceptually correct. When one of your measures is non-iterable it does the whole calculation once and then is applied to the iterable measure, then definitely result will be wrong. Thank you for great video :)
@OliviaSantiagoOn2
6 ай бұрын
Best. Clearest explanation!!! Thank you!!!🎉
@bhaskarsubbaiah6002
Жыл бұрын
Hi sir, In this lecture you told to create the virtual table using values function to get aggregated sales per day with the distinct Calender Date. But that virtual table is not in the data model so how it will change with the Initial filter context on the calender date. Please help?
@shubhampipada3130
Ай бұрын
@Goodly, so in the last example you showed of SUM and SUMX with SUMX doing the context transition, if I am not wrong, if we apply VALUES(Test Table) which would result in unique column values and then apply SUMX should work right?
@rantaleksi7086
2 жыл бұрын
Great and elaborate yet simple enough explanation for this confusing subject. I feel like I finally have a clear idea how context transition works.
@GoodlyChandeep
2 жыл бұрын
Glad that was useful 💚
@unguralasuresh3543
Жыл бұрын
good explanation .......bro
@GoodlyChandeep
Жыл бұрын
Thanks Suresh!
@emanueledelzoppo5164
Жыл бұрын
Brilliant video AS ALWAYS! I was just wondering if values(calendar[date]) could be replaced by values(sales[orderdate]). Is this makes any sense? And why/why not is necessary to use the function "related" when using a column of another table (in this case the calendar date). Hope you answer my question(s), many thanks!
@shashipaul6279
2 жыл бұрын
That's Amazing .......
@GoodlyChandeep
2 жыл бұрын
Thank you!
@sqllearning7663
3 жыл бұрын
I use Summarize function to summarize transactional table before using Iterator function It works 😁
@ssomtom
3 жыл бұрын
Great. Thx.
@bharatgarg07
4 ай бұрын
Hi Chandeep, Thanks for explaining this concept in a very easy way. I have a doubt here, why we didn't get the issue in the first example where we have multiple rows for a single date as we have in the second example.
@narendrababu2287
2 жыл бұрын
In sumx you are using again sum measure so its giving the wrong result, if you use sumx(testtable, testtable[value]) it returns the correct result. And i still don't understand why you are using sum inside sumx function.
@sass520
2 жыл бұрын
Sir in the last can example as Context Transition was not happening bcoz of no unique key, can we use Calculate with the measure?
@sarthaksharma-o3c
8 ай бұрын
Hey Chandeep i am little but confused in the tricky example part like there A is repeating 2 times then 80 is coming but in sales table trans date is also repeating why are we seeing the correct values there
@sandeepreddy7687
3 жыл бұрын
Thanks Chandeep for detailed explanation.
@taizoondean689
Жыл бұрын
Thanks for your help
@GoodlyChandeep
Жыл бұрын
Happy to help!
@HarshaVardhan-mx2lk
2 жыл бұрын
this is insane video. Superb brother... Thanks so much for the video
@hussainmeghani8785
Жыл бұрын
Do I used mention trick for max Sales made by salesman in power query
@bigger302539
2 жыл бұрын
Thank you
@info2satish
3 жыл бұрын
Wohoo! Brilliantly explained bro!😎🙏
@maryamchavoshi6523
5 ай бұрын
Thanks For the video. How can I get the data set that you used in this video?
@suryac3462
2 жыл бұрын
Thanks for the wonderful explanation. I just have one question : If there was one more column added to the mocked-up data which enables each row to be uniquely identified, will we still be getting the duplicates? since only the column filter will be applied, I would expect that we would still get them. I am just a bit confused how in the second example, regarding the calculated column, each row is uniquely identified. Can you please elaborate? Thanks a lot!
@RyanReynolds89
2 жыл бұрын
In case you’re still wondering this 7m later haha, I think I can help. If you add a column that creates a uniquely identified row, it would no longer duplicate the results and you would get the correct answer. The reason is because when Context Transition happens, now the new unique identifier column will be included in the resulting Filter Context, so it won’t pull in the other rows (such as the second row with Category A) and duplicate the results. It will be filtered to that single row and thus sum appropriately.
@Btwimreal
3 жыл бұрын
This is best explained video for understanding context transition thanks I was trying to learn it since so long finally got it keep making video U will rock....
@jjohn108
3 жыл бұрын
Best channel for DAX, PQ & PBI. 🙏
@luizkrein
8 ай бұрын
The last example I had in my work today was exactly like this one!
@alfonsorodriguezsandias8142
2 жыл бұрын
Hello, thanks for your video. How could I know the date, the day, that the maximun sale is achieved?
@GoodlyChandeep
2 жыл бұрын
Write a measure something like = CONCATENATEX ( TOPN ( 1, Calendar, [Total Sales] ), Calendar[Date], ", " )
@alfonsorodriguezsandias8142
2 жыл бұрын
@@GoodlyChandeep Hello,, thanks, it works!!
@rajeevmenon1975
Жыл бұрын
im searching for the data model you used in the video. couldnt find it
@201401128
2 жыл бұрын
Amazing, but what about the TUPLES
@vishnupp5944
Жыл бұрын
Great
@luda_c
5 ай бұрын
A brilliant explanation. Thank you!
@alterchannel2501
11 ай бұрын
Perfect. It helped me to know that every measure is wrapped around an implicit invisible CALCULATE function in Dax. That's why writing only SUM will not give the same result, you are not writing the same measure, because every measure starts invisibly with CALCULATE 😊😊 love your videos, they help me out a lot, thanks❤
@hermesjrd
3 жыл бұрын
Thanks for the time and effort taken to explain this concept
@waynethurman2144
3 жыл бұрын
Thanks!
@thepratikjoshi44
Жыл бұрын
Wow Finally understood this 😮❤
@rounakjoardar8879
3 жыл бұрын
Can you please start power bi series ?
@jayaraju6169
Жыл бұрын
Awesome. Thank you Bro for explaining the concept...🙂
@GoodlyChandeep
Жыл бұрын
Glad you like this Jaya!
@AjayGupta-vw5dt
10 ай бұрын
Hi, I have a question, is context transition somewhat similar to "Group By" in Power Query?
@GoodlyChandeep
10 ай бұрын
Yes you can some what say that
@gravelmravel
8 ай бұрын
By far the best explanation of the most advanced concept of DAX. Thank you.
@sysieWoo
Жыл бұрын
Many thanks for putting together this video. I find it very helpful. Your explanation of the definition of context transition and how it works when using the actual calculation and the measure in the iterator calculations made so much sense. You also have made it clear and easy to understand by demonstrating how it works in two simple examples. Thank you (❁´◡`❁)
@marcosmartin951
3 жыл бұрын
Genious
@malchicken
3 жыл бұрын
For [Total Sales] I wonder if the SUM function would work if a RELATED(?) function was used? I’ve read that measures and CALCULATE can take into account table relationships automatically I think, so I wonder if only the measure / CALCULATE work because they are able to bring in the relationship between Calendar and Sales table, while just the SUM by itself cannot unless it’s paired with a RELATED(?) function.
Wow, that was an amazing lesson! Broke it down so well!
@GoodlyChandeep
2 жыл бұрын
Glad you liked it!
@melomaneck
3 жыл бұрын
The best explanation of context transition on the whole of f***in youtube
@ricardo8500
Жыл бұрын
Thank you, sir.
@joaquimcosta952
2 жыл бұрын
Very very good explanation! Thank you...
@GoodlyChandeep
2 жыл бұрын
Glad you like it 😊
@cocgamingstar6990
10 ай бұрын
thank you sir
@animeshkumar1060
3 жыл бұрын
thanks a lot this was bugging me since yesterday. Finally found an apt explanation.
@BraulioPatriota
Жыл бұрын
Nice explanation!
@keerthihulagur55
Жыл бұрын
Great explanation
@need2knowtamil249
Жыл бұрын
Awesome 👍👍👍
@tuphananh2536
10 ай бұрын
Great explanation. Thank you so much!
@lilyli8390
2 жыл бұрын
Brilliant, and very easy to understand. Thanks, it solved a big problem of today.
@yanzhu2843
2 жыл бұрын
Best explanation ever. Thanks a ton!
@GoodlyChandeep
2 жыл бұрын
You're very welcome!
@aleesouti
Жыл бұрын
Excellent!! The clearest explanation of iterator functions.
@brundleseth51
2 жыл бұрын
Genial, esos ejemplos bastante ingeniosos, especialmente el último
@GoodlyChandeep
2 жыл бұрын
¡Me alegro de que haya ayudado!
@tonandaya7414
Жыл бұрын
Wow !.. I have watched other context transition videos BUT i only understand now through your explanation.. very clear with examples/illustrations.... thank you very much ! I clicked then the subscribe button :)
@GoodlyChandeep
Жыл бұрын
Glad it was helpful! :)
@bimalpatel7758
Жыл бұрын
Bhainl tu toh dev maush hai
@TheTommySp
2 жыл бұрын
Thanks Man !
@michafabich9213
2 жыл бұрын
amazing explanation, probably best on the whole internet
@dutchinfluencer
Жыл бұрын
Best explanation on the subject I've seen 👍
@GoodlyChandeep
Жыл бұрын
Thanks!
@namangarg7875
Жыл бұрын
If a person has basic understanding of DAX, then I wud highly recommend to attend his course or vdos watever suits uhh... Because this person is teaching DAX with such a simple explanation. Big fan of Mr Chandeep.
@GoodlyChandeep
Жыл бұрын
Thanks Naman :)
@gabionindia
Жыл бұрын
Awsomeeeeeeeeeeeeee!!!!!!!!!!
@mahadevshah3099
2 жыл бұрын
Awesome....Your explanations is upto the mark. Please bring some more DAX challenges. Good bless you & Cheers !!!
@GoodlyChandeep
2 жыл бұрын
Glad You like it 💚
@raviranjansingh5527
3 жыл бұрын
as i am student i am not affordable to this prices .thanks sir
Пікірлер: 173