What is your favorite font in Excel? Anna and Lisa showed me the Consolas font. It is great because you can tell zero from O and one from lower case L.
Table of Contents
(0:00) Axel font for Excel
(0:19) Typewriters without a 1 key
(0:54) People who type L instead of 1
(2:04) How I met ExcelisFun
(2:37) Make a custom Office Theme with Consolas font
(3:32) Applying a custom office theme
(3:45) Making a theme be default
(4:09) Default Font in Excel Options
Although this might seem basic, there seems to be some confusion between Connectivity Modes, Dataset Modes, and Storage Modes in Power BI. They’re all kind of related but they refer to different aspects of data usage.
In this tutorial, Greg is going to give a fundamental 101 and try to distinguish from one another the Connectivity Modes, Dataset Modes, and Storage Modes in Power BI. Understanding these modes can help users make informed decisions when selecting the appropriate options to optimize data usage and improve the performance of their reports and dashboards.
*****Video Details*****
00:00 Introduction
00:32 Usual misconceptions
01:13 Activating Direct Query
02:04 Connectivity Continue reading “Here Are The Differences Between Connectivity, Dataset and Storage Modes In Power BI”
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 (March 4, 2023) (Member Chat 2nd Half)”
Diane has a fairly complex pivot table. She is using GETPIVOTDATA to pull data from the pivot tables to a summary report in another workbook. In another section of the report, she needs to pull YTD. But this complicates the formula, because she has to add an expanding range as the months continue.
I mentioned that she could create a second pivot table that shows the sales numbers as YTD numbers. This video shows how to copy the first pivot table and how to use Running Total In to convert from monthly sales to YTD Sales.
Are you using Power BI within Microsoft Teams? Daniel joins us to show the possibility of leveraging Microsoft Teams and the different ways to use Power BI.
Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings
https://powerbi.microsoft.com/en-us/blog/announcing-embed-your-power-bi-organizational-apps-in-microsoft-teams-channels-and-meetings/
Daniel Glenn:
https://twitter.com/DanielGlenn
https://www.linkedin.com/in/danielglenn/
https://365mcs.com/
https://www.youtube.com/365mcs
📢 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
— <a Continue reading “The MAGIC of Microsoft Teams + Power BI”
Thanks for this tip from Paul A who was in my Akron seminar.
Paul uses a function like SUM(XLOOKUP:XLOOKUP) to return the total of all numbers from a start date through an end date.
Dynamic outliers are data points that significantly deviate from the typical pattern of the data over time. Identifying these outliers can help highlight underlying performance trends and provide insights for better decision-making.
In this tutorial, Sam shows how to identify dynamic outliers in your data set using DAX. By mastering these advanced concepts, you’ll be able to showcase underlying performance trends and gain valuable insights for better decision-making.
***** Video Details *****
00:00 Introduction
02:01 Classification of an outlier
03:48 Outlier vs non-outlier
05:15 Outlier measure
05:53 Total sales
09:05 Real-life applications
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – Continue reading “Break Out Outliers And Analyze Over Time – Advanced DAX Concepts [2023 Update]”
Download Zipped Folder with All Files: https://excelisfun.net/files/13-M365ExcelClassVideoFiles.zip
This video is a comprehensive lesson in Power Query Importing & Transformation Data in Excel & Power BI. This video shows extensive M Code to create formulas to convert bad data into proper data sets that can be used for analysis.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (02:24) On-Premise Folder and File Path
3. (03:11) Importing TXT and CSV files
4. (08:08) Create Dynamic File Continue reading “Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13”
Using Merge statements? Alex shows you how that can break the fold in Power Query! He’s got you covered though and shows you a different way to approach it to make folding work! Using the UI!
Alex Powers:
https://twitter.com/notaboutthecell
https://www.linkedin.com/in/alexmpowers/
https://itsnotaboutthecell.com/
📢 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 #PowerQuery #GuyInACube
In this episode of the podcast, learn from the expertise of Thomas Martens, a Microsoft Data Platform MVP and Solution Architect at Munich Re. Join us as he explores the role of a Power BI Sherpa in driving a data culture and overcoming challenges in organizations. With 25 years of experience delivering Business Intelligence, Data Warehousing, and Analytics solutions, Tom shares his insights on using Power BI to tackle analytical challenges and apply analytical methods to small and large amounts of data. In this episode, Tom discusses the importance of Power BI in fostering a data culture, the challenges faced Continue reading “Driving a Data Culture and Overcoming Challenges as a Power BI Sherpa with Thomas Martens”
subtotal a column in excel
how to add subtotal function in excel
how to formulate subtotal in excel
how to subtotal sum in excel
how to use subtotal in excel for sum
using subtotals in excel to sum
how do you do a subtotal in excel
how to automatically subtotal data in excel
how to automatically subtotal rows in excel
how to calculate subtotals in excel
how to insert subtotals into excel
excel how to make subtotals
excel how to subtotal
excel how to use subtotals
how create subtotals in excel
how do i add subtotals in excel
how do i do a subtotal in excel
how do i do subtotal in excel
how do i use the Continue reading “Adding Subtotals In Excel”
excel how to get rid of subtotals
how do i remove subtotals in excel
how remove subtotals in excel
how to do subtotal remove all in excel
how to remove a subtotal in excel
how to remove all subtotals in excel
how to remove excel subtotals
how to remove subtotal excel
how to remove subtotal in excel
how to remove subtotals in excel
how to remove the subtotal in excel
how to undo subtotals in excel
remove subtotal in excel
how to take out a subtotal in excel
how to eliminate subtotals in excel
how to remove – from excel to show subtotal