ฝัง
- เผยแพร่เมื่อ 25 มิ.ย. 2024
- In this video we will be discussing 3 simple but powerful Context Transition Examples in Power BI. we will be covering:
Example 1 - Calculate Sales for Best Selling Day of the Month
Example 2 - Calculate Best Selling Product's Sales Value
Example 3 - Calculate Best Selling Region's Sales Value
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File - goodly.co.in/simple-and-power...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
0:00 Intro
00:34 Example 1 - Calculate Sales for Best Selling Day of the Month
4:19 Re-checking the Answer Manually
7:15 Example 2 - Calculate Best Selling Product's Sales Value (Part 1)
9:11 Example 3 - Calculate Best Selling Region's Sales Value
11:06 Example 2 - Best Selling Product Names (Part 2)
15:48 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall TH-cam Channel Below
th-cam.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - วิทยาศาสตร์และเทคโนโลยี
You are the sole reason why I finally understand context transition! I have probably watched over 20 hours of TH-cam videos and nothing made sense. This video and the other one you made a couple years ago made the concept so incredibly clear. It’s actually quite simple once you understand it. I cannot thank you enough!
The explanation of the elusive Context Transition concept presented in this video is the best on the whole Internet.
Thank you! 😊
Man you are awesome. The way you go through your tutorials is amazing and really easy to follow
Glad you like them!
You are genuinely the best Powerbi teacher I have learnt from. I have no other words to say!!!!
Oh this is gold. Great examples using context transition and nifty display of problem solving. Great job!
Thanks Takpor!
I love the validation techniques too! Great helpful video!
Awesome. The clarity that you offer is unmatched.
Thanks!
Hi goodly, No body Can Explain Lik you "wonderful and clear Explanation". Just One Query When created "Virtual Table" there is No relatioship for context transition between table?
Worked great! Thanks!
Wow! This guy is an Animal! So knowledgeable yet makes it somewhat east to understand!!! Keep it up!
Great content explaining the mind boggling concepts of DAX.
Great examples! Thanks!
Glad you like them!
Very well explained. Thank you!
Very Good Explaining. Tanks
Good job!! 'it 's very simple and impressive.. Thanks to all Goodly Team :) Very well appreciated 👏
It's just awesome that measure I have been looking for few days Thank you so much sir❤️
Glad you like it!
Again, but I have to say that "you're awesome at explaining DAX"
Very cool examples. Thanks for the clear explanations.
Glad you like them!
I was looking for that solution of bringing text in measure. Thank You So much
Glad it was helpful!
Awesome 👍👍👍
Best video on Context transition concept. Watched all three videos on Context transition concept, and they were really good. Thank You.
Happy to hear that!
The best video I have ever seen in this channel, thank you very much
Glad you like it!
Brilliant explanation. Thanks
Glad you like it!
Please keep making these videos. Thank you so much
Glad you like them!
Damn awesome 👌. I'm blown away.
Thanks!
Wonderful stuff, I thought of using SELECTCOLUMNS(TOPN(1,dItems,[Tsales]),"Top",[Item] ), but don't think this would work with ties. I'm going to have to look into UNICHAR as it's not something I've ever used / understood what it's supposed to do.
Thank you mister. U do tons of good for PBI devs
My pleasure!
Really good video!
Thank You !
Superb Sir, thank you
Glad you like it!
Hoping that you can bring teach us all other course to and end up getting in career as data scientist
As always Awesome ! 😎
Thanks!
Precisely explained
Thanks!
excellent. thanks for sharing
Glad you liked it!
Come on Man... you are just awesome....
Thank you!
Awesome Video as always! You're a true inspiration!
One Question 🙋, on this example, we are showing Total which is showing a product for the total. On what basis the measure is returning the top product in total row? Eg. Total Sales for Advanced Keratin Shampoo.
The year total for example is the best selling product of that year.
The grand total product is the overall best selling product of all time.
@@GoodlyChandeep As far as I understand, question is related to 13:18 of the video.
TOPN returns the right answer if Product table is sorted by Total Sales Desc.
How do we know that it's sorted this way (not randomly, or by product name...)?
Great
Continue doing this, good job
Thanks!
ConcatenateX
I don’t know that until now. Tks
Hey Chandeep! Thanks for the awesome explanation. Can you explain where does the context transition take place in the Best Selling Product Names (last example)? As I know, for it to happen we have to have either CALCULATE or measure reference inside a row context, both of which were absent.
Your explanation would be greatly appreciated!
Context Transition takes place in the TOPN function.
TOPN is an iterator and it creates a row context. [Total Sales] as a measure is used in the row context of TOPN.
@@GoodlyChandeep Thanks a lot for the rapid response! I wasn’t considering other iterators other than the X functions.
You’re awesome!
Hi I have two visual tables in same page ,if the i select one row in table 1 it filters the value in table 2 but i need to know whether i can click on each row value in table 1 so that table 2 displays according to that is that possible?
Ace!!!!
hi sir where to get data for practice purpose ?
Check the link in the description!
Bhai tera content shaandaar laga par thoda aur umda hona chahiye..
where is the data source for the following?
Nice video, but you talk a little bit fast and it's a little bit difficult following you for understanding what you're talking about.😎
Thanks for posting! Reposted on LinkedIn ⭐⭐⭐⭐⭐⭐⭐⭐
Glad! Thanks