Month: December 2022

Transparency Magic In Power BI With DAX

Posted on by Annie D

Brian previously talked about the best way to implement conditional formatting, which is by using the field value option because you can use the transparency masks on hex codes. In this video, Brian shows how you can utilize this transparency mask.

***** Video Details *****
00:00 Introduction
00:39 The goal
01:51 Numeric parameter slider
02:01 Color
02:20 CF Bar measure
03:40 Dynamic font 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 – Continue reading “Transparency Magic In Power BI With DAX” →

Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1806-1808.xlsx
Learn how to create a worksheet formula that counts the max number of occurrences for each unique number in a column using the FREQUENCY, IF, ROW and MAX functions. This solution originally came from Colin Legg at Mr Excel Message Board in 2010.
Topics:
1. (00:00) Introduction
2. (00:05) Review consecutive number tricks
3. (00:25) Create sorted unique list with formula
4. (00:52) Create worksheet formula that counts the max number of occurrences for each unique number in a column using the FREQUENCY, IF, ROW and MAX functions
5. (03:34) Bonus Formula: Spilled MAP and LAMBDA formula
6. () Summary, Closing, Continue reading “Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808” →

How To Cluster With Power BI And Python

Posted on by Annie D

In this tutorial, Gaelim is going to show how you can do clustering in Power BI and Python, as well as discuss some of the advantages of using Python in your clustering.

***** Video Details *****
00:00 Introduction
01:29 Using Power BI for clustering
02:12 Scatter plot clustering
05:39 Pros of clustering
05:56 Cons of clustering
06:20 Using Python for clustering
06:41 Importing a Python package
07:57 Python script

***** 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 #Python #PythonTutorial #PowerBI #PowerBIDesktop #PowerBITutorial

Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1806-1808.xlsx
Learn how to use Power Query extract all records for weights that occur consecutively 3 or more times.
Topics:
1. (00:00) Introduction
2. (00:06) Review consecutive number tricks
3. (00:32) Create Names From Selection feature (Ctrl + Shift + F3) to create Defined Name for Extract Records Hurdle
4. (01:04) Import Power Query Input From Excel Worksheet and use in query, Keyboard to import data from worksheet into Power Query: Right-Click, G
5. (02:10) Import Excel Table into Power Query with keyboard
6. (02:24) Group By Feature to group by Consecutive Occurrences using 4th argument in Table.Group Power Query M Code Continue reading “Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807” →

Multi-layered Scenario Analysis Using DAX In Power BI [2022 Update]

Posted on by Annie D

Expand your thinking around what’s possible with Power BI! What you can achieve from an analytical perspective with DAX is incredible. In this video, Sam demonstrates how you can layer multiple scenarios into your analysis through supporting tables and slicers applied in a Sales & Profit data.

***** Video Details *****
00:00 Introduction
02:07 Supporting tables
05:40 Using SUMX in scenario profits measure
07:39 Checking the formula

***** 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 “Multi-layered Scenario Analysis Using DAX In Power BI [2022 Update]” →

Can you make a two-line dynamic title in Power BI?

Posted on by Annie D

Dynamic titles in Power BI can be really useful. What about a multi-line title? Patrick is answering a commenter’s question on how to create a two-line dynamic title!

Dynamic Titles in Power BI Desktop
https://www.youtube.com/watch?v=TYLKDPcvgK8

📢 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 “Can you make a two-line dynamic title in Power BI?” →

How To Integrate A Power App Into Your Power BI Report

Posted on by Annie D

In this tutorial, Tim is going to demonstrate how you can incorporate a Power App directly into your Power BI report and make the two interact together

***** Video Details *****
00:00 Introduction
00:43 Report example
02:45 Inefficiencies
03:09 The goal
05:53 Adding an app
06:22 Adding data in your app
11:28 Edit mode vs Add New Record
13:42 PowerBIIntegration.Data
15:18 Auto populate a new record
16:25 Multiple selected record
20:05 Publish app

***** 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 href="http://www.enterprisedna.co/power-bi-resources" Continue reading “How To Integrate A Power App Into Your Power BI Report” →

Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1806-1808.xlsx
Learn how to conditional format a row in a table when there are consecutive numbers in the weight column.
Topics:
1. (00:00) Introduction
2. (00:05) Intro to next three videos about Consecutive Numbers in a Column
3. (00:25) Conditional Format Row for Consecutive Numbers
4. (01:00) Build Logical Formula using OR function
5. (02:02) Mixed Cell References with Column Locked. This allows Conditional Formatting for the row.
6. (02:52) Paste Logical Formula into Conditional Fo0rmatting dialog box
7. (03:38) Summary, Closing, Video Links

Lonely Book Signings And Faster Way To Generate 729 Combinations – 2352

Posted on by Annie D

You’ve probably seen the story of Chelsea Banning in the news lately. 37 people RSVP’d to her book signing and only two showed up. That is DOUBLE the turnout for my Manhattan book signing in 2003. Also in the episode: two faster ways to generate all 729 combinations of the outcome of World Cup Group Match Play.

Thanks to Exceλambda and Kyle F. for faster ways to generate all combinations of 0, 1, and 2 for 6 World Cup Group Stage Matches.

Can you use SQL Auth with Azure Synapse Serverless?

Posted on by Annie D

When using Azure Synapse Analytics Serverless Pools, using Azure AD auth is pretty simple. But, what about SQL Auth? How do you get hat working? Patrick shows you how!

Control storage account access for serverless SQL pool in Azure Synapse Analytics
https://learn.microsoft.com/azure/synapse-analytics/sql/develop-storage-files-storage-access-control?tabs=managed-identity

Sample Script: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20221206%20-%20Connect%20to%20Serverless%20-%20Security%20Script.sql

📢 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
— <a Continue reading “Can you use SQL Auth with Azure Synapse Serverless?” →

Using LASTNONBLANK For Dynamic Sales Insights In Power BI – DAX Function Deep Dive [2022 Update]

Posted on by Annie D

In this tutorial, Sam shows how to use the LASTNONBLANK function to showcase dynamic insights such as the date of the last sale for a particular variable or element in your data set.

***** Video Details *****
00:00 Introduction
01:55 Calculating last sale date
03:00 Calculating last sale amount

***** 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 Continue reading “Using LASTNONBLANK For Dynamic Sales Insights In Power BI – DAX Function Deep Dive [2022 Update]” →

Using The Power BI “Magic” Dataset Call In Action

Posted on by Annie D

In this video, Brian shows how he and Gustaw Dudek developed the advanced analysis in their winning Challenge 23 entry, using the “magic” dataset call that he initially introduced in his previous video.

The Most Powerful Function Call In Power BI – https://youtu.be/F2M4F4sUDw8

***** Video Details *****
00:00 Introduction
05:10 Main data
05:56 Why not operate on the main data file
06:37 R script
09:41 Running in Power Query
10:30 Different applications

***** 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 Continue reading “Using The Power BI “Magic” Dataset Call In Action” →