Month: November 2022

How To Perform Conditional Full and Partial Text Replacements In Power Query

Posted on by Annie D

In this tutorial, Melissa is going to demonstrate how to perform a combination of conditional full and partial text replacements in Power Query all in one simple step.

***** Video Details *****
00:00 Introduction
00:26 Data set
00:31 Replacements list
00:54 Replacing values

***** 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 – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership Continue reading “How To Perform Conditional Full and Partial Text Replacements In Power Query” →

🔴 Power BI tips from the Pros – LIVE (Nov 19, 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 (Nov 19, 2022) (Member Chat 2nd Half)” →

How To Create Dynamic Chart Titles In Power BI

Posted on by Annie D

In this tutorial, Brian delves into his approach to a query that came up in a recent Accelerator event that involves taking selections from a slicer of a visual and incorporate that into a dynamic chart title.

***** Video Details *****
00:00 Introduction
00:40 Sample execution
01:14 Bar chart formatting
01:36 Dynamic Title measure
03:42 CF Title Color measure

***** 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 Continue reading “How To Create Dynamic Chart Titles In Power BI” →

Understanding Anomalies In Power BI With DAX – Analytical Technique [2022 Update]

Posted on by Annie D

In this video, Sam will showcase how you can really quickly and effectively understand anomalies in your data sets by combining many Power BI techniques around DAX.

***** Video Details *****
00:00 Introduction
01:40 Showcasing Anomalies In Your Data Set
03:38 Understanding Anomalies In Power BI
04:57 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 Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership Continue reading “Understanding Anomalies In Power BI With DAX – Analytical Technique [2022 Update]” →

Add a measure without Power BI Desktop (Premium)

Posted on by Annie D

Need to add a measure to your Power BI dataset? Can’t download it back in Power BI Desktop? Patrick shows you how you can still add that measure even though you can’t use Power BI Desktop!

Tabular Editor 2
https://github.com/TabularEditor/TabularEditor

Tabular Editor 3
https://tabulareditor.com/

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #DAX #GuyInACube

🔴 Power BI tips from the Pros – LIVE w/ Matthew Roche (Nov 12, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI! With special guest, Matthew Roche!

Connect with Matthew:
Twitter: https://twitter.com/SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/

💥 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 Continue reading “🔴 Power BI tips from the Pros – LIVE w/ Matthew Roche (Nov 12, 2022) (Member Chat 2nd Half)” →

How To Use Isolation Forest Machine Learning Algorithm For Outlier Detection Using Python

Posted on by Annie D

In this tutorial, Gaelim is going to show how to use the Isolation Forest machine learning algorithm to find outliers in your data, and how to fine tune this algorithm and compare to traditional ways of outlier detection.

***** Video Details *****
00:00 Introduction
00:33 Isolation Forest method vs Box Plot method
02:03 Data set
02:51 Applied steps
03:14 Python code
07:02 Traditional outlier vs Anomaly detection
08:58 Optimizing the algorithm

***** 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 Use Isolation Forest Machine Learning Algorithm For Outlier Detection Using Python” →

Have you seen the SQL Admin Pack for Azure Data Studio?

Posted on by Annie D

Working with Azure SQL Database or Azure Synapse Analytics? Want to use Azure Data Studio but missing all of the tools you used to use? Patrick looks at the SQL Admin Pack and how that can help you.

Azure Data Studio GitHub Repo
https://github.com/Microsoft/azuredatastudio

Admin Pack for SQL Server
https://github.com/microsoft/azuredatastudio/tree/main/extensions/admin-pack

📢 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
— <a Continue reading “Have you seen the SQL Admin Pack for Azure Data Studio?” →

How To Show Percentage Sales Per Custom Group Each Year In Power BI – Advanced DAX [2022 Update]

Posted on by Annie D

Ever wanted to see the percentage of how many sales can be attributed to a certain grouping or variable of say, customers, products or regions? In this video, Sam will demonstrate a great technique using DAX that will do exactly this advanced analysis.

***** Video Details *****
00:00 Introduction
01:20 Determine ranking per customer group
03:48 Determine percentage of customer group
05:14 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 – rel=”nofollow”>http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

Taking On Excel BI’s Stacked To Ordered Power Query Challenge

Posted on by Annie D

In this video, Melissa demonstrates her approach in solving Excel BI’s Stacked To Ordered Power Query Challenge. The objective for this challenge is transform a stacked data into a tabular format with the results showcased in a descending order.

Excel BI’s Stacked To Ordered Challenge: https://bit.ly/3SRptdB

***** Video Details *****
00:00 Introduction
00:51 Creating lists
01:18 Drill-down
01:27 Splitting lists
02:04 Assigning field names
02:47 Transforming into tabular format
03:16 Table.AddRankColumn
04:44 Reordering columns

***** 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 Continue reading “Taking On Excel BI’s Stacked To Ordered Power Query Challenge” →

XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1801-1804.xlsx
Learn how to
Topics:
1. (00:00) Introduction
2. (00:05) XLOOKUP Array Formula to create a Sales Rep Commission Report based on two Conditions for the commission rate.
3. (02:49) Summary, Closing, Video Links

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801
SUMIFS & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1802
LAMBDA & MAP Functions to Lookup Different Product Commission Rates for each Sales Rep. EMT 1803
XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804