Three new features coming to Excel.
1) Value Preview will evaluate part of your formula when you select it in the Excel formula bar. You don’t have to press F9 and Esc anymore.
2) AutoSave moves from an icon to Words in the Excel Title Bar
3) Small preview of Personalized Toolbar in Excel
Table of Contents
(0:00) Three new Excel Features
(0:30) F9 replaced with Value Preview
(3:57) AutoSave icon moves to Title Bar words
(5:07) Personalized Toolbar in Preview
(10:38) Wrap-up
Download Excel File: https://excelisfun.net/files/EMT1816.xlsx
Learn about new “Value Preview” for Excel Formula Elements: No More F9 & Ctrl + Z
Topics:
1. (00:00) Introduction
2. (00:01) Learn about new “Value Preview” for Excel Formula Elements: No More F9 & Ctrl + Z
3. (00:47) Closing, Video Links
#Shorts
Download Excel File: https://excelisfun.net/files/EMT1814-1815.xlsx
Learn who to copy Excel Formatting and Apply in other locations
Topics:
1. (00:00) Introduction
2. (00:05) Copy Only Formatting with the Format Painter in Ribbon
3. (00:20) Format Painter in Mini Toolbar
4. (00:31) Apply Formatting multiple Times by Double-clicking Format Painter
5. (00:43) Keyboard for Format Painter
6. (01:03) Apply Same Formatting to Many Columns Simultaneously
7. (01:19) Closing, Video Links
#Shorts
You’ve set up Power BI Incremental Refresh and there is a day that is missed because schedule refresh failed or some other reason. What happens? Do you lose that data? Patrick digs in!
📢 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 “What happens when you miss a refresh day with Power BI Incremental Refresh?”
Fake dataset is often used for testing and filling databases or maintaining user privacy by using some dummy data. Data analysts would know that manually creating fake data would be a daunting task! In this tutorial, Gaelim will demonstrate how you can easily create data using Python Faker.
*****Video Details*****
00:00 Introduction
01:28 Libraries needed
02:25 Locale
03:54 Types of data
05:11 Random element selector
05:58 Creating the dataset
***** 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 Subscription – app.enterprisedna.co/pricing
Enterprise DNA Continue reading “How To Easily Create Data With Python Faker Library”
Want to know more about a slowly changing dimension? What about the different types? Patrick goes through examples and ties in the surrogate key!
Sample: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230124%20-%20SCD%20Demo.sql
Handling Type II Dimension with the MERGE Statement
https://sqldownsouth.blogspot.com/2010/11/handling-type-ii-dimension-with-merge.html
Slowly Changing Dimension
https://en.wikipedia.org/wiki/Slowly_changing_dimension
#PowerBI #GuyInACube
I was doing a seminar recently and many people at the company were getting reports downloaded as fixed width text files.
I encouraged them to start using the Get & Transform tools in Excel for cleaning this date. After the seminar, I created a text file with many of the issues that were in their workbooks.
Table of Contents
(0:00) Fixed Width Text File for Excel
(0:50) Excel Text Import Wizard UI for Marking Column Locations
(1:19) Finding column start locations for Power Query
(1:59) Importing to Excel from Text/CSV
(2:18) Power Query incorrectly guesses comma as delimiter
(2:42) Power Query make column wider
(2:55) Power Query removing Continue reading “Excel Power Query Import And Clean Fixed Width Text Files 2359”
In this tutorial, Sam runs through how to create a dynamic table that only shows the top results across a range of measures. You can do this using a combination of DAX formula including the RANKX function. This is great ranking technique for a number of analytical scenarios in Power BI.
*****Video Details*****
00:00 Introduction
01:00 The goal
01:41 Profit growth YOY
03:40 Sales YOY
04:26 Margin growth YOY
***** 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 Subscription Continue reading “How To Create Dynamic Tables In Power BI Using RANKX”
Download Excel File: https://excelisfun.net/files/EMT1814-1815.xlsx
Learn how to remove all formatting, but leave the content in an Excel Worksheet.
Topics:
1. (00:00) Introduction
2. (00:05) Why Remove Formats?
3. (00:18) Apply Normal Style
4. (00:31) Clear Formats
5. (00:38) Keyboard shortcut #1
6. (00:56) Keyboard shortcut #2
7. (01:04) Keyboard shortcut #3
8. (01:24) Find and Fix “Numbers Stored As Text” Data Error
9. (01:45) Keyboard to convert Text Numbers back to Numbers
10. (01:49) Closing, Video Links
#shorts
There are 7 pivot table secrets in this video, and you haven’t seen six of them. The question: I have several projects in a pivot table. At the bottom, as part of the pivot table, I want an average of the non-zero rows.
The person is currently using AVERAGEIF outside of the pivot table, but that formula must be adjusted.
Today, we use a Data Model pivot table and a DAX Measure to calculate the average. The resulting pivot table has too many rows, so I use a new Set based on Rows.
I can not post the final formula here Continue reading “Excel Average Of Non-Zero Rows In Pivot Table – 2358”
In this tutorial, Sam demonstrates a cool data visualization technique RANX to change the size of a visual based on a ranking selection. Once you understand the patterns there are multiple ways you could apply this to other scenarios.
*****Video Details*****
00:00 Introduction
01:01 Supporting table
02:53 Customer ranking
04:15 Incorporating the 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 Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial
From yesterday’s live seminar, a new way to fill quarters and years with the fill handle.