Month: September 2022

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

How To Get Better Average Per Category In DAX – Why You Should Not Use CALCULATE

Posted on by Annie D

In last month’s Business Intelligence Summit, one of our speakers, Greg Deckler, presented about DAX counterculture wherein he talked about alternative uses on DAX. One of his key topics is all about the DAX function CALCULATE and why you should avoid using it especially if you’re new to DAX. In this tutorial, Greg is going to pick up on that discussion and delve into another Microsoft quick measure —Average Per Category.

***** Video Details *****
00:00 Introduction
01:54 The goal
02:07 Data model
02:55 Average per Category measure
06:00 Better Average per Category measure

***** Related Links *****
Better Average per Category – https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Average-per-Category/td-p/2758871
—

***** Continue reading “How To Get Better Average Per Category In DAX – Why You Should Not Use CALCULATE” →

Power BI Apps for multiple audiences has arrived!

Posted on by Annie D

This has been a feature that has been asked for long time! The ability to control who can see what content within a published Power BI App! You can now serve up multiple audiences within a single app.

Announcing Public Preview of Multiple Audiences for Power BI Apps
https://powerbi.microsoft.com/en-us/blog/announcing-public-preview-of-multiple-audiences-for-power-bi-apps/

Publish an app in Power BI
https://docs.microsoft.com/power-bi/collaborate-share/service-create-distribute-apps?source=recommendations

📢 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!
*******************

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

#PowerBI #Apps #GuyInACube

How To Use The ALL Function In Power BI And DAX [2022 Update]

Posted on by Annie D

The ALL function is particularly useful for removing filters and creating calculations on all the rows in a table. In this video, Sam shows how you can use the ALL function in Power BI with DAX with specific use cases.

***** Video Details *****
00:00 Introduction
01:05 Total sales of each customer
02:04 ALL sales
03:45 Replacing customer names with customer index
04:01 Referencing the entire table instead of column name
04:32 Percent of sales

***** 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 “How To Use The ALL Function In Power BI And DAX [2022 Update]” →

Text Formulas & Functions in Excel Worksheet and Power Query – 365 MECS 06

Posted on by Annie D

Download Excel file: https://excelisfun.net/files/06-M365ExcelClass.xlsx
Download pdf notes: https://excelisfun.net/files/06-M365ExcelClass.pdf
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
Topics in video:
1. (00:00) Introduction
2. (00:55) Join three items with the Join Operator, Ampersand &
3. (01:57) Why you use formulas rather than Flash Fill
4. (02:18) TEXTJOIN function to join three items with
5. (03:02) CONCAT function to join three items with
6. (03:16) Extract data from cell with dash delimiter to use in lookup formula. Learn about TEXTBEFORE, TEXTAFTER and XLOOKUP functions.
7. (04:43) XLOOKUP Error: Data Mismatch and how to fix Continue reading “Text Formulas & Functions in Excel Worksheet and Power Query – 365 MECS 06” →

What’s the real size of your data model in Power BI?

Posted on by Annie D

From Power BI Desktop, to Task Manager, to different spots in the Power BI service – why are the sizes different? What’s going on? How can you tell what the real size is? Well, it depends! Marco Russo joins Patrick to explain.

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

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

#PowerBI #DataModel #GuyInACube

Excel IF Contains – 2514

Posted on by Annie D

Excel IF Contains
Excel IF cell contains text
Excel IF contains
excel like wildcard
excel wildcard
excel like wildcard if

How can you test which cells in Excel contain text? Can you use an IF statement in Excel to find which cells contain certain text?

This video looks at COUNTIF, FIND, SEARCH, LOWER, SIGN, ISNUMBER, IFERROR functions.

Table of Contents
(0:00) Question
(0:22) Check for equality
(0:41) Wildcards fail in IF
(1:05) Using COUNTIF with wildcard
(1:39) Using FIND in Excel
(2:23) Adding SIGN, IFERROR, LOWER
(2:59) Using SEARCH in Excel
(3:25) Using ISNUMBER with SEARCH
(4:22) Excel IF contains solution
(4:44) Finding Contains using Filter
(5:11) Nancy Faust

How To Do Text Analysis Using Python To Identify Parts Of Speech In Texts In Power BI

Posted on by Annie D

In this video, Gaelim is going to demonstrate how to do text analysis using Python to identify parts of speech in texts brought into Power BI

***** Video Details *****
00:00 Introduction
01:15 Source data
01:59 Filtered rows
02:20 Code
08:16 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
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 Continue reading “How To Do Text Analysis Using Python To Identify Parts Of Speech In Texts In Power BI” →

Harvest Power BI Slicer Selections To Use With Other Measures — Advanced DAX [2022 Update]

Posted on by Annie D

In this tutorial, Sam show how to write an advanced DAX formula to harvest (capture) a selection made within a slicer visual then integrate that back into other measure calculations.

***** Video Details *****
00:00 Introduction
00:28 Data Set
01:07 Adding Percentage Change To The Total Sales Table
02:49 Turning Percentage Change Table Into A Slicer
04:20 Fixing An Error Resulting From Lack Of Selection
05:44 Creating Total Scenario Sales Measure
06:19 Clicking Different Selections In the Slicer To Get Corresponding Results
06:36 Other Uses For Harvesting Slicer Selections

***** 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 “Harvest Power BI Slicer Selections To Use With Other Measures — Advanced DAX [2022 Update]” →

How To Automatically Remove All Empty Columns In Power Query

Posted on by Annie D

In this video, Melissa demonstrates how you can automatically remove all empty columns from a table in Power Query. Melissa’s approach will involve the standard Table.Profile M library function and its additional aggregates parameter to add a non-empty count column.

***** Video Details *****
00:00 Introduction
00:12 Sample query
01:36 Data set
02:13 Select columns
04:08 Add non-empty count column
09:07 Custom function

***** 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 Automatically Remove All Empty Columns In Power Query” →

REPLAY Power BI Optimization Q&A – LIVE w/ Marco Russo (Aug 5, 2022)

Posted on by Annie D

Prioritizing questions around 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 courses available to Continue reading “REPLAY Power BI Optimization Q&A – LIVE w/ Marco Russo (Aug 5, 2022)” →

excelisfun’s new book The Only App That Matters Book is Released!!! Microsoft 365 Excel = The Best!

Posted on by Annie D

Aug 1, 2022 and the physical copy of excelisfun’s new book “The Only App That Matters” is out!
Publisher Bill Mr Excel Jelen $28.88 offer at this link between Aug 4 and Aug 8 with promo code promo code “OCHO3”: https://excel.bookstore.ipgbook.com/microsoft-365-excel–the-only-app-that-matters-products-9781615470709.php
Buy Book at Amazon (available more quickly and in more locations) for 34.99 (hard copy) or $18 for Kindle: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700