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

How To Fix Measure Totals With Deneb

Posted on by Annie D

In this tutorial, Greg tackles a couple of his favorite topics in Power BI — Measure Totals and Matrix Table Visualizations. Greg will particularly demonstrate how you can fix incorrect measure totals using Deneb.

***** Video Details *****
00:00 Introduction
01:58 Overview of custom visual
02:35 Measure Total issue
04:04 Deneb visual
13:06 Matrix visual

***** Related Links *****
Creating a Deneb Matrix by Power BI Guy – https://youtu.be/kXS8haj1PDs

***** 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 Continue reading “How To Fix Measure Totals With Deneb” →

Handling Multiple Dates in Power BI With DAX [2022 Update]

Posted on by Annie D

In this video, Sam shows how to work with multiple dates within an underlying fact table by using the USERELATIONSHIP function within CALCULATE through a common scenario that data analysts will most likely to encounter.

***** Video Details *****
00:00 Introduction
0:43 Data model
01:50 Natural filtering with the active relationship
03:38 USERELATIONSHIP
05:10 Common confusion with multiple dates
05:48 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 – 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 Page DAX Continue reading “Handling Multiple Dates in Power BI With DAX [2022 Update]” →

Answer If Margins Are Expanding or Contracting Through Time With Power BI [2022 Update]

Posted on by Annie D

Great way to showcase the analytical power of using DAX in Power BI. Learn how to show if sales margins (or any types of margins) are changing through time. Look to find trends in the data using Power BI.

***** Video Details *****
00:00 Introduction
00:55 Profit margins
02:23 Profit growth
04:29 Identifying trends
07:00 Individual transactions

***** 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 Page DAX Reference Guide Download Continue reading “Answer If Margins Are Expanding or Contracting Through Time With Power BI [2022 Update]” →

🔴 Power BI tips from the Pros – LIVE (Dec 17, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 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

📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE (Dec 17, 2022) (Member Chat 2nd Half)” →

Build a Slicer Panel in Power BI (2022/2023)

Posted on by Annie D

Let’s look at how to build a slicer panel in your Power BI Report! This can help to reduce visuals on the canvas and also make for an app like experience. There are some things to think about though.

For a trip down memory lane, here’s Adam’s 2019 Slicer Panel Video: https://www.youtube.com/watch?v=xy9nmSQeUWg

📢 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
— rel=”nofollow”>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 page – https://guyinacube.com/tools/

#PowerBI #GuyInACube

A Power Query tip for you

Posted on by Annie D

You probably know that you can concatenate strings in Power Query. Not big news there. But do you know how to change the order of how things are concatenated? Patrick shows you how!

📢 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 “A Power Query tip for you” →

Extending Layered Scenario Analysis Techniques – Advanced DAX and Power BI [2022 Update]

Posted on by Annie D

Scenario analysis is all about predicting what outcome could occur in the future. Sam is a huge promoter of this type of analysis in Power BI, he thinks it makes a big difference and adds real value to organisations. In this video, Sam showcases many steps around layering scenario variables into your analysis.

***** Video Details *****
00:00 Introduction
01:54 Layering scenarios
02:09 Total sales
03:04 Scenario profits
05:18 Cumulative scenarios
07:11 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 – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power Continue reading “Extending Layered Scenario Analysis Techniques – Advanced DAX and Power BI [2022 Update]” →