Month: February 2023

Excel Suggest The Next Awesome Excel Idea – 2366

Posted on by Annie D

Do you love Excel? Do you have a feature that would make Excel easier for you? Write up your idea and post it to the new Feedback Forum for the Excel team. Other people can vote for your idea and many ideas each year are added to Excel.

The Feedback portal for Excel is at: https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472

Vote for my idea to use the Custom Lists when renaming copied worksheets, vote here: https://feedbackportal.microsoft.com/feedback/idea/13963988-a0a0-ed11-a81b-000d3a0450e3

If you post a great idea at the Feedback forum, let me know the title in a YouTube comment and I will vote Continue reading “Excel Suggest The Next Awesome Excel Idea – 2366” →

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

Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX

Posted on by Annie D

Are you trying to work out trends in customer behaviour or would like to target marketing campaigns more specifically to relevant customers? In this video, Sam demonstrates how you can calculate the difference in days between purchases or events in Power BI using DAX formulas. He is going to use some advanced logic using the FILTER and CALCULATE functions.

*****Video Details*****
00:00 Introduction
02:20 Data set
03:17 Last date of purchase
05:01 Difference between purchases
09:22 Conclusion

***** 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 “Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX” →

Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/12-M365ExcelClassVideoFiles.zip
Full Free M Code Class from Basic to Advanced in Excel and Power BI Power Query taught by Excel MVP and Highline College Professor, Mike Girvin. Full Class: Microsoft 365 Excel Complete Story.
This video covers.
1. (00:00) Introduction
2. (00:26) Define M Code
3. (03:05) Power Query and M Code are in Both Excel and Power BI Desktop
4. (05:08) Advanced Editor button in Excel & Power BI Desktop
5. (05:39) Power BI Desktop “Enable Load”
6. (06:22) M Code Basics, tour of Power Query Editor and the three locations to view and change M Code. We Continue reading “Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12” →

Let’s see if ChatGPT knows what’s coming next for Power BI…

Posted on by Annie D

Everyone is making videos on ChatGPT and trying to solve problems. What about telling the future? Let’s see if ChatGPT can tell us what’s coming next for Power BI!

📢 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 – <a href="https://guyinacube.com/tools/" Continue reading “Let’s see if ChatGPT knows what’s coming next for Power BI…” →

Building an Inclusive Data Culture with Chris Wagner

Posted on by Annie D

Are you struggling to create a data culture in your organization that can support everyone inside the company, not just the executive? Chris Wagner, a director of data solutions at Baker Tilly, is here to help. With over two decades of experience in the data analytics space, Chris has worked with large organizations to create modernized data and analytical strategies. He will provide actionable ideas on how to build a data culture that can help individuals take their next step forward in their data career. This article will cover three focus areas of data engineering, analytics and data science, and Continue reading “Building an Inclusive Data Culture with Chris Wagner” →

Excel Reverse Wildcard Search – 2365

Posted on by Annie D

VLOOKUP, XLOOKUP, and SUMIFS all allow a wildcard in the Lookup_Value. But today, Chris wants wildcards wrapped around the lookup table! After trying XLOOKUP, FILTER, and COUNTIF, I finally end up with TEXTJOIN, IF, and SEARCH. Do you have a better way?

Table of Contents
(0:00) Use wildcard for the lookup range
(0:34) XLOOKUP, FILTER, COUNTIF failed
(0:54) SEARCH function on an array
(2:11) TEXTJOIN, IFERROR, and SEARCH
(3:15) Surprisingly difficult

Calling a Stored Procedure using Incremental Refresh in Power BI? We think so!

Posted on by Annie D

Have you wanted to use a Stored Procedure with Incremental Refresh? Patrick has a way that you can do just that!

Sandeep’s blog:
https://pawarbi.github.io/blog/power%20bi/powerquery/queryfolding/m/optimization/2022/01/25/parameter-valuenativequery-query-folding-where-clause-in-powerbi.html

Stored Procedures: https://learn.microsoft.com/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver16

Sample:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2023/20230201%20-%20IR%20with%20SP.zip

📢 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 Continue reading “Calling a Stored Procedure using Incremental Refresh in Power BI? We think so!” →

How To Bulk Copy Measures From Different Reports In Power BI

Posted on by Annie D

You’ll most probably encounter having to reuse the same measure when working with multiple Power BI reports. In this video, Brian shares a handy trick for copying measures from one report to another. There is no direct way to do this in Power BI but this is something you can achieve using the Tabular Editor.

*****Video Details*****
00:00 Introduction
00:27 Case scenario
00:45 DAX Offsets table
01:22 Copying measures

***** 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 Continue reading “How To Bulk Copy Measures From Different Reports In Power BI” →

Excel Secret To Maximizing Euro Jackpot Winnings – 2364

Posted on by Annie D

Markus is looking for Excel help to pick numbers for the Euro Jackpot where you have to choose 5 numbers from 1 to 50. In this video, I share secrets from my late friend Dogtrack Bill.

To use the number picker in a free Excel Online, follow this link:
https://1drv.ms/x/s!As7G72Sl487JljvjcWPxwg0_pTe1?e=CMGO1E

The Euro Jackpot payout for matching 5 numbers with no bonus numbers is a parimutuel system. A fixed percentage of the betting pool is split between all people that matched five numbers. To maximize the payout if you win, choose numbers that are not likely to be chosen by Continue reading “Excel Secret To Maximizing Euro Jackpot Winnings – 2364” →