Category: Power BI

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

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

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

How To Increase Scatterplot Options With Python For Power BI

Posted on by Annie D

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

Analyze Margin Changes Over Time – Analytics With Power BI & DAX [2022 Update]

Posted on by Annie D

In this tutorial, Sam showcases how you can analyze the changes to margin over time. This example specifically deals with profit margins but, this technique could be applied to any type of margin analysis.

***** Video Details *****
00:00 Introduction
02:39 Calculating core measures
03:57 Calculating margins from last quarter
04:51 Calculating margin differential
05:19 Visualizing the data

***** 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 Continue reading “Analyze Margin Changes Over Time – Analytics With Power BI & DAX [2022 Update]” →