Visually see where you BROKE the fold in Power Query

Rule #1 – DON’T BREAK THE FOLD! There is an amazing feature that lets you see where this fold was broken, and I’m guessing you didn’t even know it was there! Adam shows you where to go.

Query plan for Power Query (Preview)
https://learn.microsoft.com/power-query/query-plan

📢 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

Can I Sum Data in Excel that is Filtered – 2574

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

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 Sum Time in Excel – 2573

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

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”

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

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?”

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

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”

How to Do Running Total Sum in Excel #shorts

Two ways to calculate a running total in Excel.
The first method is the sum of the cell in this row and the running total from above.
The second method is an expanding dynamic range.

This video answers these common search terms:
Calculate Cummulative Sum In Excel
Excel How To Do A Cumulative Sum
How To Add Cumulative Sum In Excel
How To Calculate A Cumulative Sum In Excel
How To Calculate A Running Sum In Excel Table
How To Caluclate A Cumulative Sum In Excel
How To Create A Cumulative Sum In Excel
How To Create A Running Sum On Excel
How To Create Excel Running Sum
How To Cumulative Sum Continue reading “How to Do Running Total Sum in Excel #shorts”

Using Excel To Calculate Five Number Summary – 2571

The five-number summary in Excel is Min, first quartile, median, upper quartile and Max. This video shows three ways:
Method 1: Three formulas
Method 2: LET function
Method 3: LAMBDA function

This video answers these Search terms:
does excel already have a 5 number summaryy option
how do you obtain a five number summary in excel
how do you use excel to find 5 number summary
how to create a 5 number summary in excel
how to create a five number summary in excel
how to determine five number summary excel
how to do 5 number summary in excel
how to do a 5 number summary in excel
how to do a five Continue reading “Using Excel To Calculate Five Number Summary – 2571”

Excel Random No Repeats – Even Shorter for Microsoft 365 – Episode 2570

How to generate a random selection in Excel with no repeats.

Choose random names from the Data Set, but do it without repeating a namek. In a revisit to Episode #1471, how will Bill assure that there are no repeats in the Random selection? Follow along with Episode #2570 today to learn the answer and solve the challenge.

This video requires new Excel functions available in Microsoft 365. If you don’t yet have RANDARRAY, SORTBY, or SEQUENCE, then use the old method in video 1471: https://www.youtube.com/watch?v=g8FFgxmE70g

The PowerBall lotto formula shown near the end of the video is:
=TEXTJOIN(“, “,,SORT(TAKE(
SORTBY(SEQUENCE(69),RANDARRAY(69)),5)),”PB=”&RANDBETWEEN(1,26))

Table Continue reading “Excel Random No Repeats – Even Shorter for Microsoft 365 – Episode 2570”