Simple and Powerful Context Transition Examples in Power BI
HTML-код
- Опубликовано: 11 июл 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 RUclips Channel Below
ruclips.net/channel/UCGQE...
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 RUclips 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! 😊
I love the validation techniques too! Great helpful video!
You are genuinely the best Powerbi teacher I have learnt from. I have no other words to say!!!!
Great content explaining the mind boggling concepts of DAX.
Man you are awesome. The way you go through your tutorials is amazing and really easy to follow
Glad you like them!
Oh this is gold. Great examples using context transition and nifty display of problem solving. Great job!
Thanks Takpor!
Worked great! Thanks!
Very well explained. Thank you!
Good job!! 'it 's very simple and impressive.. Thanks to all Goodly Team :) Very well appreciated 👏
Wow! This guy is an Animal! So knowledgeable yet makes it somewhat east to understand!!! Keep it up!
Awesome. The clarity that you offer is unmatched.
Thanks!
Very Good Explaining. Tanks
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?
Great examples! Thanks!
Glad you like them!
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!
Very cool examples. Thanks for the clear explanations.
Glad you like them!
The best video I have ever seen in this channel, thank you very much
Glad you like it!
I was looking for that solution of bringing text in measure. Thank You So much
Glad it was helpful!
It's just awesome that measure I have been looking for few days Thank you so much sir❤️
Glad you like it!
Awesome 👍👍👍
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.
Please keep making these videos. Thank you so much
Glad you like them!
Brilliant explanation. Thanks
Glad you like it!
Damn awesome 👌. I'm blown away.
Thanks!
Thank you mister. U do tons of good for PBI devs
My pleasure!
Really good video!
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...)?
Precisely explained
Thanks!
Superb Sir, thank you
Glad you like it!
As always Awesome ! 😎
Thanks!
excellent. thanks for sharing
Glad you liked it!
Again, but I have to say that "you're awesome at explaining DAX"
Hoping that you can bring teach us all other course to and end up getting in career as data scientist
Continue doing this, good job
Thanks!
Great
Come on Man... you are just awesome....
Thank you!
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?
ConcatenateX
I don’t know that until now. Tks
Ace!!!!
Best Selling Product name....for this Inside Concatenate Function you can use MAXX , AM i right???? Please respond
Bhai tera content shaandaar laga par thoda aur umda hona chahiye..
where is the data source for the following?
hi sir where to get data for practice purpose ?
Check the link in the description!
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