Month: December 2022

Excel LAMBDA function – Every Single Things You Ever Wanted To Know – 365 MECS 10

Posted on by Annie D

Download pdf notes: https://excelisfun.net/files/10-M365ExcelClassStart.xlsx
Download Excel file: https://excelisfun.net/files/10-M365ExcelClassFinished.xlsx
This is a 1 hour 45 min. video about everything that the Excel LAMBDA function can do. This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports.
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:52) Overview
3. (02:42) Defined Names
4. (12:24) First look at LAMBDA to create a re-usable function
5. (19:00) Advanced Formula Environment
6. (23:40) Summary of LAMBDA
7. (25:20) Rate Of Change Re-usable LAMBDA function
8. Continue reading “Excel LAMBDA function – Every Single Things You Ever Wanted To Know – 365 MECS 10” →

Excel Sparkling Christmas Tree with Changeable Ornaments with LAMBDA function! EMT 1809

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1809.xlsx
This amazing Christmas Gift is from YouTube Teammate ExcelLambda!! Download the workbook to get your free Christmas Package with many holiday formula surprises!!! Go Team!
Topics:
1. (00:00) Christmas Tree Wishes!
2. (00:23) How to use LAMBDA to make Excel Sparkling Christmas Tree with Changeable Ornaments
3. (01:10) Happy Holidays!

We Wish You A Merry Xmas by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/

Artist: http://audionautix.com/

Analyze Margin Changes Over Time – Analytics With Power BI & DAX [2022 Update]

Posted on by Annie D

In this tutorial, Sam showcases how you can analyze the changes to margin over time. This example specifically deals with profit margins but, this technique could be applied to any type of margin analysis.

***** Video Details *****
00:00 Introduction
02:39 Calculating core measures
03:57 Calculating margins from last quarter
04:51 Calculating margin differential
05:19 Visualizing the 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 Continue reading “Analyze Margin Changes Over Time – Analytics With Power BI & DAX [2022 Update]” →

How To Fix Measure Totals With Deneb

Posted on by Annie D

In this tutorial, Greg tackles a couple of his favorite topics in Power BI — Measure Totals and Matrix Table Visualizations. Greg will particularly demonstrate how you can fix incorrect measure totals using Deneb.

***** Video Details *****
00:00 Introduction
01:58 Overview of custom visual
02:35 Measure Total issue
04:04 Deneb visual
13:06 Matrix visual

***** Related Links *****
Creating a Deneb Matrix by Power BI Guy – https://youtu.be/kXS8haj1PDs

***** 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 “How To Fix Measure Totals With Deneb” →

Handling Multiple Dates in Power BI With DAX [2022 Update]

Posted on by Annie D

In this video, Sam shows how to work with multiple dates within an underlying fact table by using the USERELATIONSHIP function within CALCULATE through a common scenario that data analysts will most likely to encounter.

***** Video Details *****
00:00 Introduction
0:43 Data model
01:50 Natural filtering with the active relationship
03:38 USERELATIONSHIP
05:10 Common confusion with multiple dates
05:48 Conclusion

***** 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 Continue reading “Handling Multiple Dates in Power BI With DAX [2022 Update]” →

Answer If Margins Are Expanding or Contracting Through Time With Power BI [2022 Update]

Posted on by Annie D

Great way to showcase the analytical power of using DAX in Power BI. Learn how to show if sales margins (or any types of margins) are changing through time. Look to find trends in the data using Power BI.

***** Video Details *****
00:00 Introduction
00:55 Profit margins
02:23 Profit growth
04:29 Identifying trends
07:00 Individual transactions

***** 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 Continue reading “Answer If Margins Are Expanding or Contracting Through Time With Power BI [2022 Update]” →

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

Build a Slicer Panel in Power BI (2022/2023)

Posted on by Annie D

Let’s look at how to build a slicer panel in your Power BI Report! This can help to reduce visuals on the canvas and also make for an app like experience. There are some things to think about though.

For a trip down memory lane, here’s Adam’s 2019 Slicer Panel Video: https://www.youtube.com/watch?v=xy9nmSQeUWg

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

A Power Query tip for you

Posted on by Annie D

You probably know that you can concatenate strings in Power Query. Not big news there. But do you know how to change the order of how things are concatenated? Patrick shows you how!

📢 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 Continue reading “A Power Query tip for you” →

Extending Layered Scenario Analysis Techniques – Advanced DAX and Power BI [2022 Update]

Posted on by Annie D

Scenario analysis is all about predicting what outcome could occur in the future. Sam is a huge promoter of this type of analysis in Power BI, he thinks it makes a big difference and adds real value to organisations. In this video, Sam showcases many steps around layering scenario variables into your analysis.

***** Video Details *****
00:00 Introduction
01:54 Layering scenarios
02:09 Total sales
03:04 Scenario profits
05:18 Cumulative scenarios
07:11 Conclusion

***** 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 Continue reading “Extending Layered Scenario Analysis Techniques – Advanced DAX and Power BI [2022 Update]” →

20221213 Profile with Azure Data Studio

Posted on by Annie D

📢 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/

#AzureSQL #AzureDataStudio #GuyInACube