Author: Annie D

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (June 29, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (June 29, 2024)” →

Unlock Data Factory Power with Existing Connections

Posted on by Annie D

Minimize the clicks you take when setting up connections within Data Factory pipelines to get data QUICKLY! Patrick shows you different ways you can leverage existing connections that you’ve already set up within Pipelines in Microsoft Fabric.

📢 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***
🛠 Continue reading “Unlock Data Factory Power with Existing Connections” →

Leverage Power Query Parameters with Power BI Paginated reports

Posted on by Annie D

You’ve seen how you can use Power Query within Power BI Paginated reports. Now Patrick shows you how you can leverage parameters to drive interactivity!

📢 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 page – https://guyinacube.com/tools/

#PowerBI #Paginated #GuyInACube

How to create a slick way to adjust your Power BI visual

Posted on by Annie D

Create a slick way to adjust your visual by way of bookmarks leveraging the Navigation button. Adam shows you how to set this approach up to get a nice look and feel.

📢 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 page Continue reading “How to create a slick way to adjust your Power BI visual” →

Excel Introduces TRANSLATE and DETECTLANGUAGE Functions – Episode 2645

Posted on by Annie D

Microsoft Excel Tutorial: Excel Introduces TRANSLATE and DETECTLANGUAGE Functions.

Unlock the Power of Excel’s New Functions: TRANSLATE and DETECTLANGUAGE

To download the workbook from today: https://www.mrexcel.com/youtube/rOQraANkokQ/

Hey Excel enthusiasts! If you found this video helpful, don’t forget to click Like down below. It helps more people discover this content. In this video, we’re diving into two amazing new Excel functions: TRANSLATE and DETECTLANGUAGE. These functions are game-changers, making it easier than ever to work with different languages in Excel.

First up, the TRANSLATE function. This powerful tool allows you to translate any text from one language to another effortlessly. Just enter Continue reading “Excel Introduces TRANSLATE and DETECTLANGUAGE Functions – Episode 2645” →

Microsoft Revokes excelisfun MVP Status!

Posted on by Annie D

Today, July 10, 2024, I got a letter from Microsoft that says I am no longer an Excel MVP. I posted about the same number of videos, files and free classes as the year before. I just passed 1,00,000 subscribers. I give everything away for free. But Microsoft says: NO MVP for excelisfun. So be it. I will keep making Excel and Power BI videos because it is fun!!!

Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1860.xlsx
Learn how to extract a lookup value from a description and use it to lookup a value without getting an error.
Topics:
1. (00:00) Introduction
2. () Use lookup value from description to lookup a value. MID function and XLOOKUP with Plus Zero.
3. () Summary
4. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #xlookup #exceltips

UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1861.xlsx
Download Timing Test file: https://excelisfun.net/files/EMT1861TestResults.xlsx
When extracting a sorted unique list with a formula, it is more efficient to use UNIQUE-SORT, rather than SORT-UNIQUE.
Topics:
1. (00:00) Introduction
2. SORT-UNIQUE combination tends to calculate slowly.
3. UNIQUE-SORT tends to calculate quickly.
4. () Summary
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #sort #unique #arrayformulas #excelarrys #dynamicspilled arrays

Discover Adam and Patrick’s Epic 2024 Adventure

Posted on by Annie D

July is here and conferences are coming for the 2nd half of 2024. Learn where you’ll find Adam and Patrick and how you can register. We hope to see you there!

SQL Saturday Baton Rouge 2024 – July 27th
https://sqlsaturday.com/2024-07-27-sqlsaturday1076/

Data Saturday Dallas – September 7th
https://datasaturdays.com/Event/20240907-datasaturday0056

Power Platform Conference – Las Vegas, NV – September 18-20th
https://powerplatformconf.com/

European Microsoft Fabric Community Conference – Stockholm, Sweden – Sept 24-27th
https://aka.ms/fabcon-europe

📢 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 “Discover Adam and Patrick’s Epic 2024 Adventure” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 13, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 13, 2024)” →

Multiple DAX Measure updates in DAX Query View? Yes, Please!

Posted on by Annie D

We got some new updates for the DAX Query view in Power BI Desktop that take it to a whole other level! Patrick shows you how you can start using it with models in the service and more!

Power BI July 2024 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-july-2024-feature-summary/#post-27650-_Toc1615654178

📢 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