Month: January 2023

Create Dynamic Visuals Based On Ranking In Power BI With DAX

Posted on by Annie D

In this tutorial, Sam shows how you can rank customers in Power BI with DAX, based on their sales or profits and also create visualizations that dynamically change for additional filters that you may put in place.

***** Video Details *****
00:00 Introduction
01:13 Total costs and total profits measures
02:29 RANKX function
03:50 ALL function
04:22 Top 10 table
05:20 Fixing incorrect total
07:13 Dynamic visualizations

***** 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 BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events Continue reading “Create Dynamic Visuals Based On Ranking In Power BI With DAX” →

Why You Should Take Advantage Of The DAX Table Constructor

Posted on by Annie D

In today’s video, Greg showcases one of his most used DAX constructs which he thinks is often overlooked by the DAX community — the DAX Table Constructor. He’ll be showing you what it’s all about and some examples on how he used it on some of his real-world works.

*****Video Details*****
00:00 Introduction
01:48 Table 1
03:18 Table 2
05:48 Single column
06:09 Multiple columns
06:52 Table 3
09:52 BASE example
11:00 GAMMA example
11:27 Text to Table example
12:19 XOR example

***** 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 BI Resources – Continue reading “Why You Should Take Advantage Of The DAX Table Constructor” →

Extract All Digits from Range & List in Column – Excel Magic Trick 1812 #shorts

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1812.xlsx
Learn how to Extract All Digits From Range & List in Column. Learn a Microsoft Excel 365 Formula and a formula that works in any version.
Topics:
1. (00:00) Introduction
2. (00:10) Microsoft 365 Excel Formula. See the functions: MID, SEQUENCE, SUM, LEN.
3. (01:25) Formula that works in any version of Excel. See the functions: INDEX, ROWS, MID, SUM, LEN, ROW and INDIRECT.
4. (02:13) Convert Text Numbers To Numbers
5. (02:34) Summary, Closing, Video Links

#Shorts

How To Write And Debug M Code More Effectively

Posted on by Annie D

In today’s video Brian discusses three important techniques that will help you write and debug M code more effectively: 1) the use of pseudocode: 2) the use of table duplicate to create “save points” to bookmark your coding/debugging progress; and 3) the use of record structures to break complex M expressions down into component variables, similar to DAX coding and debugging techniques.

*****Video Details*****
00:00 Introduction
01:15 Pseudocode solution
04:59 Debugging
09:27 Referencing
04:40 The errors
05:34 Record structure
09:28 Table duplicate
16:06 Recap

***** 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 – Continue reading “How To Write And Debug M Code More Effectively” →

ChatGPT Versus 2 Humans Writing Power Query – 2355

Posted on by Annie D

Laura B has a tricky Power Query question today. She needs to delete all rows where B=C and D=E. Bill solves this in the Power Query Editor but knows it is not efficient.

He turns to ChatGPT – an Artificial Intelligence tool that is in a free research preview. Bill is amazed at how quickly ChatGPT writes M code for Power Query. But then he bangs his head against the wall trying to get it to work.

See why Stack Overflow has banned ChatGPT because it generates code that is usually wrong but looks like it could work.

Finally, we turn to Continue reading “ChatGPT Versus 2 Humans Writing Power Query – 2355” →

How To Use Query Parameter In Power BI [2023 Update]

Posted on by Annie D

In this tutorial, Sam shows how to use the query parameter feature inside of Power BI. You can bring significant scale to your reporting by using this feature without the need for duplicated reporting. Build a model once and then use this to add additional filters to your reports.

*****Video Details*****
00:00 Introduction
00:24 Query parameters
01:54 Creating a parameter
02:48 Integrating a Parameter into a query
04:50 Dealing with blanks in the table

***** 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 BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA Continue reading “How To Use Query Parameter In Power BI [2023 Update]” →

Visualizing Data and Building Dashboards in Excel & Power BI – 365 MECS 11

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/11-M365ExcelClassVideoFiles.zip
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
This video covers the basics of visualizing data, then shows how to create five different types of Dashboards.
Topics in video:
1. (00:00) Introduction
2. (00:21) Topics
3. (01:06) Why Visualize? Table or Visualization?
4. (03:44) Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule”
5. (05:56) Tables Formatting Rules
6. (12:03) Conditional Formatting
7. (15:41) Column and Bar Charts to compare differences across categories
8. (24:00) Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar
9. Continue reading “Visualizing Data and Building Dashboards in Excel & Power BI – 365 MECS 11” →

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