Download Excel File: https://excelisfun.net/files/EMT1810.xlsx
Learn how to do a 3-way or 2-way lookup in the Excel worksheet with XLOOKUP or in Power Query (in Excel and Power BI) using UnPivot and Merge.
Topics:
1. (00:00) Introduction
2. (00:05) 3-way lookup in the Excel worksheet with XLOOKUP
3. (01:45) 3-way in Power Query (in Excel and Power BI) using UnPivot and Merge
4. (03:46) Summary, Closing, Video Links
Struggling to get dates when using a between date slicer, or a before, or after? Patrick walks through a straightforward way to get the date values when using a date slicer in Power BI!
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Continue reading “Wait! Using a Power BI Date slicer, what are my dates when using between?”
In this video, Brian will be sharing an installment to his mini series we call “Buried Treasures within Power BI”. He’ll dive into the function SELECTEDVALUE, which is one of the most common DAX functions used to harvest values from slicers and is probably in almost all of your Power BI reports.
***** Video Details *****
00:00 Introduction
00:38 Model
03:23 The goal
04:18 The logic
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – <a Continue reading “DAX Magic With The SELECTEDVALUE Optional Parameter In Power BI”
Using Aggregation Tables in Power BI? Average calculations not working because they aren’t hitting the agg? Patrick explains why this is happening and how you can correct it to get the expected result.
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools Continue reading “How to handle Aggregation tables with Averages in Power BI”
In this video, Sam demonstrates how you can calculate the month on month change using custom calendars in Power BI using DAX. Learning this technique can be extremely beneficial for businesses and individuals looking to analyze their data more effectively. By using this technique, you can better understand trends and patterns in your data over time, and make more informed decisions based on this information.
***** Video Details *****
00:00 Introduction
01:43 Previous Month Sales
03:23 The formula
06:19 Month On Month change
07:03 Conclusion
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE Continue reading “Calculating Month On Month Change – Custom Calendars In Power BI [2023 Update]”
We’ve talked about using a surrogate key in your data warehouse whether that’s Azure Synapse Analytics or something else. Patrick looks at why you should consider this even if you aren’t using a slowly changing dimension.
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check Continue reading “To Surrogate Key or Not…”
Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc…
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training Continue reading “🔴 Starting 2023 w/ Marco Russo LIVE (Jan 7, 2023)”
In this tutorial video, Gaelim will be guiding you through examples of increasing the customization options for scatterplots in Power BI using Python that will let you enhance the appearance and functionality of scatterplots in Power BI.
***** Video Details *****
00:00 Introduction
00:39 Data set
02:23 Power BI scatterplot
03:10 Traditional scatterplot
04:50 LM plot
05:34 KDE plot
07:42 Histogram plot
09:23 Combination plot
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Continue reading “How To Increase Scatterplot Options With Python For Power BI”
Happy New Year! I was scrolling through Facebook when Maria O pointed out that 2023 is 7*17^2. That seems interesting. Are there other times in our lifetime that the year is N*NN*^N?
It last happened in 2020. We have a run of them, coming up:
2023: 7*17^2
2025: 9*15^2
2028: 3*26^2
But even cooler is 2025, which is the perfect square of 45^2. Unless you were alive in 1936 or will be alive in 2116, the square year of 2025 will be the only square in our lifetimes.