Category: Business

Can I Sum Data in Excel that is Filtered – 2574

Posted on by Annie D

How can you sum data in Excel that has been filtered?
You have to apply the filter first and then AutoSum in Excel.
This video answers all of these common search terms:
can i sum data in excel that is filtered
excel how to make sum change with filter
excel how to sum a filter
excel how to sum cells from a filter
excel how to sum filtered column
excel how to sum with filter
how do i sum filtered data in excel
how do you get a sum from excel when filtering
how do you sum a filtered column in excel
how do you sum only filtered items in excel
how do Continue reading “Can I Sum Data in Excel that is Filtered – 2574” →

Checking out the new Power BI RLS Editor

Posted on by Annie D

Take a look at the new Row-Level Security (RLS) editor within Power BI Desktop! Patrick explores how it works and what to look out for in the Preview.

Power BI February 2023 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-february-2023-feature-summary/

Documentation
https://learn.microsoft.com/power-bi/enterprise/service-admin-rls#define-roles-and-rules-in-power-bi-desktop-using-enhanced-row-level-security-editor-preview

📢 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/
— <a href="https://guyinacube.com" Continue reading “Checking out the new Power BI RLS Editor” →

How To Convert Continuous Data Into Categorical In Power BI Using Python

Posted on by Annie D

Knowing how to convert continuous data into categorical data in Power BI using Python is important because it allows for better visualization and analysis of data through grouping and summarizing data by categories, providing more meaningful insights and enabling better decision-making. It also helps to simplify complex data and makes it easier to communicate insights to stakeholders.

In this tutorial, Gaelim is going to explore several ways on how you can convert continuous data into categorical data using some Python code that you can easily apply in Power BI.

*****Video Details*****
00:00 Introduction
00:43 Overview of the different methods
01:50 Dataset
02:35 Source
03:12 Categorizing the Continue reading “How To Convert Continuous Data Into Categorical In Power BI Using Python” →

How To Sum Time in Excel – 2573

Posted on by Annie D

Why can’t Excel correctly sum a simple timesheet in Excel?
This video shows method 1: Choose the crazy 37:30:55 number format. Method 2: Convert the times to hours when you subtract start time from end time.

This video answers all of these common search terms:
excel how to calculate sum of time
hot to do a times sum in excel
how do find the sum of time in excel
how do i sum time in excel ?
how do you format a cell in excel to sum time youtube
how do you sum time format in excel
how do you sum time in excel
how do you sum time inexcel
how Continue reading “How To Sum Time in Excel – 2573” →

How to Make a Sum Negative in Excel #shorts

Posted on by Annie D

How to make a sum negative in Excel.
You have a sum in Excel but want a minus sign in front.
When you total checks, how do you make the sum negative in Excel?

This video answers these common search queries:
How To +/- A Sum In Excel
How To Do Minus Sum In Excel
How To Do Minus Sums On Excel
How To Make A Sum Negative In Excel
How To Make Sum Negative In Excel
How To Minus A Sum On Excel
How To Put A Total Sum As A – In Excel
How To Put A Total Sum As A negative In Excel
How To Put A Total Sum Continue reading “How to Make a Sum Negative in Excel #shorts” →

Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/16-M365ExcelClassVideoFiles.zip
This video teaches how to use the Group By feature in Power Query. The 10 examples cover many helpful applications of how to use Group By for calculations and Data Analysis. Basics to Advanced Lessons.

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. (00:32) What does Group By do?
3. (01:07) When to use Group By or other tools such as PivotTables
4. (01:44) Basics of Group Continue reading “Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16” →

What’s a Junk Dimension and when should you use it?

Posted on by Annie D

Maybe you’ve heard of the concept of a junk dimension but what exactly is it and when should you use it? Patrick breaks down this dimensional modeling concept.

Junk Dimensions
https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/junk-dimension/

Design Tip #113 Creating, Using, and Maintaining Junk Dimensions
https://www.kimballgroup.com/2009/06/design-tip-113-creating-using-and-maintaining-junk-dimensions/

Sample Script:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230321%20-%20Junk%20Dimension.sql

📢 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 href="http://www.facebook.com/guyinacube" Continue reading “What’s a Junk Dimension and when should you use it?” →

How To Know What Are Causing The Changes In Your Data Using DAX [2023 Update]

Posted on by Annie D

DAX is a powerful formula language used in Power BI that allows you to create complex calculations and custom measures. It enables you to analyze data at a more granular level and gain deeper insights into your business operations.

Additionally, the ability to identify and understand the root cause of changes in your data can help you make more informed decisions and take proactive steps to address any issues. In this tutorial, Sam demonstrates how you can combine a number of DAX formulas, and how to calculate and find out why and what are causing certain changes in your data.

*****Video Continue reading “How To Know What Are Causing The Changes In Your Data Using DAX [2023 Update]” →

Excel Sum Across Worksheets When Rows Are Lined Up Or Not – 2572

Posted on by Annie D

Some call it a 3D reference or a spearing formula. If your Excel worksheets are all perfectly lined up, you can use this formula to sum across worksheets in Excel.
But if your worksheets are not in the same sequence, then you can use TOCOL, SORT, UNIQUE, and SUMIFS to solve the problem.

This video answers these search terms:
how ot easy sum tabs in excel
how sum across multiple sheets in excel
how to calculate sum from other tabs in excel
how to do sum across two worksheets in excel
how to do sum of cells in multiple sheet in excel
how to get multi excel sheets Continue reading “Excel Sum Across Worksheets When Rows Are Lined Up Or Not – 2572” →

INDEX & RANDARRAY Functions to Create Table of Data. # Short Excel Magic Trick 03

Posted on by Annie D

Learn how to create a random data set with Excel formulas that you can use for demonstrations, teaching and testing models.
Download Excel File: https://excelisfun.net/files/SEMT0002-0003.xlsx
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp,
#indexfunction #index #randarray #table #dataanalysis #dataanalytics #datatables #datatable #randomdata #radomixedata
#randarray

Format Total Row in Dynamic Spilled Array (Conditional Formatting) # Short Excel Magic Trick 02

Posted on by Annie D

Learn how to add conditional formatting to Dynamic Spilled Array Reports using Conditional Formatting.
Download Excel File: https://excelisfun.net/files/SEMT0002-0003.xlsx
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #microsoftexcel #microsoftmvp,
#conditionalformatting #formatting #ReportFormat
#DynamicSpilledArrays #array #arrayformula #excelformulas #formatArrays