The rapid advancements in artificial intelligence (AI) technology have been nothing short of groundbreaking. The implications for businesses, jobs, and education are profound, and it can be both awe-inspiring and intimidating to consider what the future may bring. Brian and Sam discuss AI’s impact on coding, and how it has already begun to shift the way we do things. With a $20 billion investment from Microsoft and AI being embedded in parts of Azure, it is clear that the technology is advancing at an alarming rate. How will we use AI to our advantage, and how can it be used Continue reading “Unpack the Impact of AI on Business, Jobs, and Education with Brian Julius”
Month: February 2023
Excel Formula To Extract Country From Phone Number – 2370
Is there an Excel formula that can return the country name from the telephone number?
This video shows you how. To make your life easier, add this worksheet with five named ranges already in it:
https://1drv.ms/x/s!As7G72Sl487Jlj1AUGli1Zgx0OgW?e=0Bda0m
Time to look at the new INDEX function in DAX and Power BI
The latest DAX functions in Power BI can be very “power”ful! Patrick starts by looking at the INDEX function to solve a customer problem!
Blog announcement:
https://powerbi.microsoft.com/blog/power-bi-december-2022-feature-summary/#post-21693-_Toc121395731
INDEX function (DAX)
https://learn.microsoft.com/dax/index-function-dax
WINDOW function (DAX)
https://learn.microsoft.com/dax/window-function-dax
Chris Webb’s Blog
https://blog.crossjoin.co.uk/2023/01/02/why-dax-window-functions-are-important-for-performance-in-power-bi-directquery-mode/
Jeffrey Wang’s Blogs on Window Function
https://pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/
https://pbidax.wordpress.com/2022/12/23/introducing-dax-window-functions-part-2/
📢 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
— rel=”nofollow”>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 #GuyInACube
How To Automatically Delete Unused Columns And Measures In Power BI
A good practice to have before finalizing your Power BI reports is to delete the unused columns and measures, and this will greatly help to optimize and to further emphasize the important aspects of your report. But this can be a very laborious task in itself. In today’s video, Brian is going to show how you can easily identify and automatically delete unused columns and measures in Power BI using the Measure Killer.
*****Video Details*****
00:00 Introduction
00:45 Measure killer
01:59 Deleting unused columns
04:16 Deleting unused measures
***** Related Links *****
Measure Killer by Brunner BI – https://en.brunner.bi/measurekiller
***** Learning Power BI? ***** Continue reading “How To Automatically Delete Unused Columns And Measures In Power BI”
Excel Holidays Between Two Dates – 2369
After episode 2363, a pair of great questions and a tip.
Tip 1: When specifying the Holiday Range in Excel, make the range into a table and then name the range. That way, when you add new holidays at the bottom, the named range will automatically expand.
Question 1: How many holidays fall between two dates?
Question 2: What is the list of holidays between two dates?
This video includes details on NETWORKDAYS.INTL and FILTER functions.
You will also see how I take two sub-formulas that were in different cells and combine them into a single formula by scooping the characters out of each formula.
Table Continue reading “Excel Holidays Between Two Dates – 2369”
My Poem – An Ode to Excel
Written by Magic AI and I
Oh Excel, you’re a sight to behold
Your powers so vast, your secrets untold
Your formulas and charts, they never grow old
Your uses are vast, your features unfold
Your beauty’s unmatched, your power’s divine
Your data so precise, and figures so fine
From pivot tables to macros, you make life sublime
A spreadsheet maven, your use is so prime
Oh Excel, you make the mundane sublime
Your features so strong, all those bold lines
From tracking expenses to uncovering goldmines
You make the mundane task feel more like a sweet rhyme
Your power and ease, it’s hard to describe
Your talents so numerous, they stretch as far as the eye can see
You make the task of data entry so much less of a chore
So, Excel, my dear partner and friend, I thank you for making my work life, oh so much more
Excel How To Create A PDF Of Just One Page – #shorts
Mary Ellen asks: It is easy to print one page of an Excel print range. But how do you send just one page to a PDF? The answer is there, but hidden.
Continuing the T-SQL journey with OVER and RANK
Continuing our T-SQL journey, Patrick explores the use of the OVER and RANK functions in combination with common table expressions (CTE) in Azure SQL Database and Azure Synapse Analytics.
RANK (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/functions/rank-transact-sql?view=sql-server-ver16
SELECT – OVER Clause (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16
WITH common_table_expression (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16
📢 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
— Continue reading “Continuing the T-SQL journey with OVER and RANK”
Excel Hold Alt+1 To Repeatedly Run 1st QAT Icon Perhaps Increase Decimal 2368
A cool Excel trick from Geert Delmulle – you can increase decimal repeatedly by holding down Alt+1. This works if you move the Increase Decimal icon to one of the first 9 spots on the Quick Access Toolbar.
Table of Contents
(0:00) Fast Way to Increase Decimal in Excel
(0:47) After Alt key, use 1-9 for first 9 QAT icons
(1:02) Hold Alt+2 to run 2nd QAT icon repeatedly
(2:30) Adding icons to the Excel QAT
(2:54) Moving QAT icon to beginning
(3:06) Finding icons not on Ribbon for QAT
(4:06) Save icon too far left after AutoSave removed
Excel You CAN Change The Font Size In The Formula Bar – Shorts
Why is the text in the formula bar so small? If you are on a Zoom call or doing a presentation, it is impossible for the audience to see. There is an amazing trick for making the text in the Excel formula bar HUGE. Try this out.
Time Based Cohort Analysis – How To Setup Your Data Model In Power BI
In this tutorial, Sam is going to demonstrate how you can create time based cohort insights within Power BI. You can use this strategy for whatever cohort you’re trying to devise. Cohort Analysis has been popularized by SAS applications. So, you should group your customers based on when they’re churning. You can create incredible analysis in Power BI using this technique.
*****Video Details*****
00:00 Introduction
01:02 Review on cohort analysis
02:06 Creating cohorts
04:58 Cohort Months table
07:39 Cohort analysis insights
10:14 Churning formulas and examples
***** 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 Continue reading “Time Based Cohort Analysis – How To Setup Your Data Model In Power BI”
Hide Excel Pivot Table Rows Using Sets And Then Edit The MDX – 2367
If you need to hide some rows in an Excel pivot table, you can Create a Set Based on Row Items.
This is a rarely used feature: First, it is only available if you choose Add This Data To The Data Model.
Once you create a set, it is a bit strange to remove rows. And if you add data later, you have to go back in to edit the set. Excel offers to let you edit the MDX, but what is MDX?
Thanks to David Jefferson who provided a comment to a YouTube video, he shows how to Continue reading “Hide Excel Pivot Table Rows Using Sets And Then Edit The MDX – 2367”