Category: Business

How To Debug With SELECTEDVALUE Optional Parameter In Power BI

Posted on by Annie D

In this video, we’re going to continue with Brian’s mini series that we call “Buried Treasures within Power BI”. Brian previously did a similar video delving into the SELECTEDVALUE Optional Parameter, but this time, Brian wants to show a totally different on how you can use this for debugging complex measures. Brian will show a new technique based on some new features in Power BI as well.

***** Video Details *****
00:00 Introduction
01:28 Data model
01:50 DAX measure
04:05 The problem
04:44 Debugging
08:05 Context transition
11:28 TOCSV

***** Related Links *****
DAX Magic With The SELECTEDVALUE Optional Parameter – https://youtu.be/iZM96Ie4Dpg

***** Learning Power BI? *****
FREE Continue reading “How To Debug With SELECTEDVALUE Optional Parameter In Power BI” →

Showcasing Trends Using Moving Average Techniques In Power BI [2023 Update]

Posted on by Annie D

A lot of time at a daily level the data is too busy to showcase trends in your analysis. In this tutorial, Sam explains how to use moving average DAX techniques to make data trends more visually striking in Power BI. He also provides tips for using moving averages to effectively communicate data insights in a compelling way.

***** Video Details *****
00:00 Introduction
02:03 Sales last quarter
03:12 Moving averages
04:12 DATESINPERIOD
05:15 Moving average last quarter

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power Continue reading “Showcasing Trends Using Moving Average Techniques In Power BI [2023 Update]” →

Classification Models In Power BI Using Python – Logistic Regression and Gradient Boost

Posted on by Annie D

In this video, Gaelim demonstrates how you can incorporate classification models in Power BI using, with a focus on logistic regression and gradient boost. Logistic regression and gradient boost are two popular classification algorithms that are widely used in the field of data science. Gaelim shows you how to use Python to build these models in Power BI, and how you can use them to make predictions and inform your business decisions

***** Video Details *****
00:00 Introduction
00:28 Types of model
00:46 Data set
01:52 Python script
09:21 Pros/cons of logistic regression
09:59 Pros/cons of gradient boost

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Continue reading “Classification Models In Power BI Using Python – Logistic Regression and Gradient Boost” →

Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1811.xlsx
Learn how to extract customer names who did not buy products from a specified list with worksheet formulas and Power Query.
Topics:
1. (00:00) Introduction
2. (00:41) Worksheet Formulas and Functions: FILTER, XMATCH, ISNA, AND, and COUNT.
3. (03:27) Formula Bonus #1: LAMBDA
4. (03:56) Formula Bonus #2: Use COUNT function to extract names when they bought no products, one or more products or all products
5. (04:35) Power Query using Group By feature and List.ContainsAny M Code function
6. () Summary, Closing, Video Links

Reusing Moving Averages – Power BI & DAX Trend Analysis Technique [2023 Update]

Posted on by Annie D

If you can understand how the moving average pattern or combination of DAX formula works, then you will find that you can easily reuse it over and over again. In this tutorial, Sam will showcase how you can do exactly this, which is a great way to smoothen busy data or showcase general trends over time.

***** Video Details *****
00:00 Introduction
01:23 Moving averages for Total Sales
03:00 Profit Margin average
03:38 Average of Total Profits
04:43 Moving averages for Total Customers

***** 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 Continue reading “Reusing Moving Averages – Power BI & DAX Trend Analysis Technique [2023 Update]” →

Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810

Posted on by Annie D

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

Wait! Using a Power BI Date slicer, what are my dates when using between?

Posted on by Annie D

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?” →

DAX Magic With The SELECTEDVALUE Optional Parameter In Power BI

Posted on by Annie D

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” →

How to handle Aggregation tables with Averages in Power BI

Posted on by Annie D

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” →

Calculating Month On Month Change – Custom Calendars In Power BI [2023 Update]

Posted on by Annie D

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]” →

To Surrogate Key or Not…

Posted on by Annie D

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…” →

🔴 Starting 2023 w/ Marco Russo LIVE (Jan 7, 2023)

Posted on by Annie D

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)” →