Retrieving previous period values in Power BI is a common task, but retrieving previous week values requires some special attention. In this video, Brian discusses two straightforward and versatile methods for obtaining previous week values that can be useful additions Continue reading “How To Obtain Previous Week Values In Power BI”
Month: January 2022
Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about how to use Power Query to import and transform data, use array formulas to create a 5-Number Summary, and who to create a Box & Whiskers Chart from a 5-column Improper Data Continue reading “Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas”
How we optimize Power Query and Power BI Dataflows
Let’s go into Adam’s mind as he optimizes Power Query to make some Power BI Dataflows run faster to avoid resource usage. The result is INSANE AMAZING!
Power Query M function reference
https://docs.microsoft.com/powerquery-m/power-query-m-function-reference
📢 Become a member: rel=”nofollow”>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/
#PowerBI #PowerQuery #GuyInACube
Transformation High-Level Analytics w/Power BI
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
January 20th, 5pm New York (ET), 2pm Los Angeles (PT), 10pm London (GMT)
January 21st , 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “Transformation High-Level Analytics w/Power BI”
How To Effectively Use Sheet View While Collaborating In Excel 2461
Sheet view in Excel is useful if multiple people are editing the same workbook. Say that one person wants to filter to Open orders and the other wants to see closed orders. One wants the data sorted descending and the Continue reading “How To Effectively Use Sheet View While Collaborating In Excel 2461”
Power BI Premium Gen2 updates (January 2022)
There are some updates for Power BI Premium Gen2 you should know about! Adam talks about the upcoming migration date and more! Are you ready for Gen2?
Plan your transition to Power BI Premium Gen2
https://docs.microsoft.com/power-bi/admin/service-premium-transition-gen1-to-gen2
Install the Gen2 metrics Continue reading “Power BI Premium Gen2 updates (January 2022)”
How To Dynamically Control Font Properties Via DAX
In this video, Brian will introduce the K Team Solutions’ HTML & CSS Viewer, a custom visual he recently started using that provides a lot of flexibility and capabilities that are not possible within native Power BI visuals particularly in Continue reading “How To Dynamically Control Font Properties Via DAX”
Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about the z-score (number of standard deviations) and how to calculate it and use it in the Empirical Rule and Chebyshev’s Theorem.
Topics:
1. (00:00) Introduction to Z-Score
2. (01:23) Basics of Z-Score Calculations using math Continue reading “Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations”
Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values
I know of nine ways in Excel to Paste Values.
One of these is about to be wiped out by Microsoft and the Excel team.
I think all nine of them are important!
Here are the nine ways that I know of to Continue reading “Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values”
The Two Digit Year Setting Does Not Work If You Never Change It – 2458B
An update on video 2458. There is a setting about how Excel interprets a two-digit year. Microsoft changed this setting from 2029 to 2049. But Excel refuses to accept the 2049 setting. Unless you change the setting in Control Continue reading “The Two Digit Year Setting Does Not Work If You Never Change It – 2458B”
The F4 Key To Repeat Is My Favorite Excel Shortcut – 2460
The F4 key in Excel has a dual life. Most people know F4 as the way to put dollar signs in a formula reference. But when you are not editing a formula, F4 will repeat the last command.
Some of you Continue reading “The F4 Key To Repeat Is My Favorite Excel Shortcut – 2460”
Working With Expanded Tables In Power BI
For today’s tutorial, we are going to take a look at Expanded Tables, which you’ll most probably have encountered while working with DAX. Expanded Tables are very tricky to work with and they must have messed up you calculations at Continue reading “Working With Expanded Tables In Power BI”