Month: October 2024

Excel Which Invoices Add Up To This Check Amount – 2658

Posted on by Annie D

Microsoft Excel Tutorial: Which Invoices Add Up To This Check Amount – Faster method using Python in Excel.

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

Today, I’m excited to share a powerful solution to a problem I used to call the “knapsack problem” in accounts receivable. We often face scenarios where customers send a payment without specifying which invoices are covered—leaving us to solve the puzzle! In this video, I’ll show you how to identify which invoices match a specific payment amount using Python in Excel, without the need for a Copilot subscription. 🚀

This challenge involves finding a combination Continue reading “Excel Which Invoices Add Up To This Check Amount – 2658” →

Using AI voice tutors to learn new data and programming skills

Posted on by Annie D

In this video we go through how amazing AI voices are becoming. They can already walk you through in a very customized way how to learn about new skills in the data and programming space. You can acquire advanced new skills much faster than you ever thought possible if you embrace this new way of learning.

Introduction to the excelisfun Channel at YouTube: Free Videos, Files and Full Free Courses!!

Posted on by Annie D

Home page with free videos, files and full free courses: https://www.youtube.com/@excelisfun
This is an introduction to the excelisfun channel at YouTube, where the videos, practice files and full courses are all free! Mike Girvin created this channel back in 2008 and have posted over 3,700 videos, over 10,000 practice files and over 100 playlists and classes to learn from.

1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1862.xlsx
Learn how to add a formula helper column to the data set to group the dates by half year increments in a PivotTable.
Topics:
1. (00:00) Introduction
2. () Viewer Question
3. () Helper Column Formula
4. () PivotTable
5. () Summary
6. () Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #pivottable #grouping #groupby #formulas #functions

Creative way to use Sempy to update a Power BI report definition

Posted on by Annie D

Need to do a bulk change of something in your Power BI report? The new Power BI report format enables some slick automations. Patrick uses Sempy to get this done!

What is semantic link?
https://learn.microsoft.com/fabric/data-science/semantic-link-overview

Items – Get Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/get-item-definition?tabs=HTTP

Items – Update Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/update-item-definition?tabs=HTTP

📢 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
— rel=”nofollow”>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 #report #GuyInACube

Happy little accidents with the Power BI Card Visual

Posted on by Annie D

Ready to take the Power BI card visual to the next level? Adam tinkers to get it to look just right. It’s a lot of customization but the outcome is way better than the starting point.

Create a (new) card visualization in Power BI Desktop (preview)
https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-new-card?tabs=On-the-ribbon

📢 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 “Happy little accidents with the Power BI Card Visual” →

REPLAY Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (July 27, 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

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: <a href="https://www.youtube.com/" Continue reading “REPLAY Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (July 27, 2024)” →

Dive into Power BI and Microsoft Fabric – IN PERSON – two events!

Posted on by Annie D

We are presenting a full day introduction to Microsoft Fabric at two different events in September! This is also important for Power BI folks to understand what all is available to them. Join us to get up to speed quickly!

Data Saturday Dallas (Dallas-Fort Worth, Texas:
Friday, September 6, 2024

Data Saturday Registration:
https://www.eventbrite.com/e/data-saturday-dallas-tickets-905734084027
Data Saturday Pre-Con Sign up:
https://www.eventbrite.com/e/harnessing-the-power-of-microsoft-fabric-tickets-931743197987

SQLKonferenz (Hanau, Germany):
Monday, September 30, 2024
https://sqlkonferenz.de/precon-workshops-2024/
https://sqlkonferenz.de/registration/

📢 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 Continue reading “Dive into Power BI and Microsoft Fabric – IN PERSON – two events!” →

Which Microsoft Fabric SQL Analytics Endpoint should you use?

Posted on by Annie D

Both the Microsoft Fabric lakehouse and warehouse have a SQL Analytics Endpoint. But they have different limitations. Which one is the right one to use? Patrick breaks it down!

Better together: the lakehouse and warehouse
https://learn.microsoft.com/fabric/data-warehouse/get-started-lakehouse-sql-analytics-endpoint

📢 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 “Which Microsoft Fabric SQL Analytics Endpoint should you use?” →