Simple and Powerful Context Transition Examples in Power BI

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 มิ.ย. 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
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 74

  • @christophernicholas778
    @christophernicholas778 10 หลายเดือนก่อน +2

    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!

  • @cbaide100
    @cbaide100 ปีที่แล้ว +2

    The explanation of the elusive Context Transition concept presented in this video is the best on the whole Internet.

  • @terrylee2094
    @terrylee2094 ปีที่แล้ว +5

    Man you are awesome. The way you go through your tutorials is amazing and really easy to follow

  • @tak0331
    @tak0331 ปีที่แล้ว +1

    Oh this is gold. Great examples using context transition and nifty display of problem solving. Great job!

  • @buddymartin71
    @buddymartin71 ปีที่แล้ว

    I love the validation techniques too! Great helpful video!

  • @meghasyam427
    @meghasyam427 4 หลายเดือนก่อน

    You are genuinely the best Powerbi teacher I have learnt from. I have no other words to say!!!!

  • @sandip_bettereveryday
    @sandip_bettereveryday ปีที่แล้ว +2

    Awesome. The clarity that you offer is unmatched.

  • @aijaz4441
    @aijaz4441 8 หลายเดือนก่อน

    Great content explaining the mind boggling concepts of DAX.

  • @lmk001
    @lmk001 3 หลายเดือนก่อน

    Worked great! Thanks!

  • @user-kc1gv7hl4u
    @user-kc1gv7hl4u 10 หลายเดือนก่อน

    Very well explained. Thank you!

  • @ericlandry3971
    @ericlandry3971 ปีที่แล้ว

    Wow! This guy is an Animal! So knowledgeable yet makes it somewhat east to understand!!! Keep it up!

  • @muratsahinel7302
    @muratsahinel7302 9 หลายเดือนก่อน

    Good job!! 'it 's very simple and impressive.. Thanks to all Goodly Team :) Very well appreciated 👏

  • @joaopinaledo9675
    @joaopinaledo9675 9 หลายเดือนก่อน

    Very Good Explaining. Tanks

  • @bradj229
    @bradj229 ปีที่แล้ว

    Very cool examples. Thanks for the clear explanations.

  • @mohammed333suliman
    @mohammed333suliman ปีที่แล้ว

    The best video I have ever seen in this channel, thank you very much

  • @pmsocho
    @pmsocho ปีที่แล้ว

    Great examples! Thanks!

  • @vishaljhaveri7565
    @vishaljhaveri7565 ปีที่แล้ว

    Best video on Context transition concept. Watched all three videos on Context transition concept, and they were really good. Thank You.

  • @nishantkumar9570
    @nishantkumar9570 ปีที่แล้ว

    I was looking for that solution of bringing text in measure. Thank You So much

  • @b0rme
    @b0rme ปีที่แล้ว

    Please keep making these videos. Thank you so much

  • @seamushand8439
    @seamushand8439 ปีที่แล้ว

    Brilliant explanation. Thanks

  • @RidharvJoshi
    @RidharvJoshi ปีที่แล้ว +1

    It's just awesome that measure I have been looking for few days Thank you so much sir❤️

  • @need2knowtamil249
    @need2knowtamil249 11 หลายเดือนก่อน

    Awesome 👍👍👍

  • @bhaskarsubbaiah6002
    @bhaskarsubbaiah6002 ปีที่แล้ว

    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?

  • @navisalomi
    @navisalomi ปีที่แล้ว +1

    Damn awesome 👌. I'm blown away.

  • @KirillBezzubkine
    @KirillBezzubkine ปีที่แล้ว

    Thank you mister. U do tons of good for PBI devs

  • @surajchavan6447
    @surajchavan6447 ปีที่แล้ว

    As always Awesome ! 😎

  • @MrKamranhaider0
    @MrKamranhaider0 ปีที่แล้ว

    Precisely explained

  • @hariprasad289
    @hariprasad289 ปีที่แล้ว

    Superb Sir, thank you

  • @atanasprodatanasov9233
    @atanasprodatanasov9233 ปีที่แล้ว

    Really good video!

  • @hoaithuongluu2869
    @hoaithuongluu2869 11 หลายเดือนก่อน

    Again, but I have to say that "you're awesome at explaining DAX"

  • @unnikrishnansanthosh
    @unnikrishnansanthosh ปีที่แล้ว

    excellent. thanks for sharing

  • @williamarthur4801
    @williamarthur4801 ปีที่แล้ว

    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.

  • @mageshwarans5367
    @mageshwarans5367 ปีที่แล้ว

    Continue doing this, good job

  • @arunkumarkesavan6077
    @arunkumarkesavan6077 ปีที่แล้ว

    Come on Man... you are just awesome....

  • @vishnupp5944
    @vishnupp5944 หลายเดือนก่อน

    Great

  • @senthamilvm1982
    @senthamilvm1982 ปีที่แล้ว +1

    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.

    • @GoodlyChandeep
      @GoodlyChandeep  ปีที่แล้ว

      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.

    • @denissipchenko2455
      @denissipchenko2455 ปีที่แล้ว

      @@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...)?

  • @owenagitza9506
    @owenagitza9506 ปีที่แล้ว +1

    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!

    • @GoodlyChandeep
      @GoodlyChandeep  ปีที่แล้ว +3

      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.

    • @owenagitza9506
      @owenagitza9506 ปีที่แล้ว

      @@GoodlyChandeep Thanks a lot for the rapid response! I wasn’t considering other iterators other than the X functions.
      You’re awesome!

  • @sujit3375
    @sujit3375 ปีที่แล้ว

    Hoping that you can bring teach us all other course to and end up getting in career as data scientist

  • @AbbyRani
    @AbbyRani ปีที่แล้ว

    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?

  • @EricaDyson
    @EricaDyson ปีที่แล้ว

    Ace!!!!

  • @willianthalles
    @willianthalles ปีที่แล้ว

    ConcatenateX
    I don’t know that until now. Tks

  • @kunalr_ai
    @kunalr_ai ปีที่แล้ว

    Bhai tera content shaandaar laga par thoda aur umda hona chahiye..

  • @prasad9976
    @prasad9976 ปีที่แล้ว

    hi sir where to get data for practice purpose ?

    • @GoodlyChandeep
      @GoodlyChandeep  ปีที่แล้ว

      Check the link in the description!

  • @TusharPant-mu1js
    @TusharPant-mu1js 7 หลายเดือนก่อน

    where is the data source for the following?

  • @afignu77
    @afignu77 ปีที่แล้ว

    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.😎

  • @tomr9969
    @tomr9969 ปีที่แล้ว

    Thanks for posting! Reposted on LinkedIn ⭐⭐⭐⭐⭐⭐⭐⭐