Shoutin’ Sam has an Excel question.
This video shows many ways to answer different questions.
=FILTER() in Excel
=XLOOKUP in Excel
=TEXTJOIN in Excel
=INDEX(FILTER()) in Excel
Category: Power Query
Provide data lake access with Azure Synapse Analytics
Using a lake database with Azure Synapse Analytics and struggling to figure out permissions needed for your data readers? Patrick and Adam show you what’s missing!
Azure Synapse Access Control
https://learn.microsoft.com/azure/synapse-analytics/security/synapse-workspace-access-control-overview
How to set up access control for your Azure Synapse workspace
https://learn.microsoft.com/azure/synapse-analytics/security/how-to-set-up-access-control
Control storage account access for serverless SQL pool in Azure Synapse Analytics
https://learn.microsoft.com/azure/synapse-analytics/sql/develop-storage-files-storage-access-control?tabs=user-identity
📢 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!
*******************
— <a href="http://twitter.com/guyinacube" Continue reading “Provide data lake access with Azure Synapse Analytics”
Excel Sum The Comma Delimited Numbers From One Cell – 2372b
Om asks: I have 123,413,413,1352,244 in a single cell.
There are many numbers with commas in between in each cell.
How to Sum all the numbers using a formula?
I don’t want to use Text to Column.
By the way, it is Excel 2010.
I use Brad Yundt’s three-line VBA function to split the numbers.
Then Excel formulas to sum them.
Also, an easier formula if you have Microsoft 365.
Table of Contents
(0:00) Sum all comma-delimited numbers in cell using an Excel formula
(0:19) Easy solution with TEXTSPLIT
(0:32) Switch to VBA for Brad Yundt Splitter code
(0:55) Using SPLITTER custom function in Excel
(1:25) Wrap up with Wally & Nancy
Numbers 1 to 100000 in Excel #Shorts
YouTube viewer asks: How to generate numbers 1 to 100000?
There are many ways to do this in Excel. I will show you two methods in this short video.
Power Query Insert Blank Row After Each Group – 2372
Back in episode 2359, I needed to add a blank row after every group of names. Although I was already in Power Query, I went out to Excel to add the blank rows.
Several people commented with code to add a blank row after each group in Power Query. Thanks to @BillSzysz1 @radosawpoprawskiyourfriend769 @GeertDelmulle Rico S and Suat Ozgur for guiding me on how to add one line of M code to my query.
I am at that stage in my Power Query journey that I prefer to do everything in the Power Query editor. Once I switch over to the advanced Continue reading “Power Query Insert Blank Row After Each Group – 2372”
🔴 Power BI tips from the Pros – LIVE (Feb 11, 2023) (Member Chat 2nd Half)
Join us live as we answer your questions about Power BI!
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE (Feb 11, 2023) (Member Chat 2nd Half)”
Excel Count Super Bowl Squares By Name – 2371
A question from @chwang06 : Asks how to count Super Bowl Squares by the name in the squares.
In this video, I will show how to get a list of players with =UNIQUE(SORT(TOCOL(C3:L12))) and then count how many times each person played using =COUNTIFS(C3:L12,C17#)
Table of Contents
(0:00) Question: Count Excel Super Bowl Squares by Name
(0:35) Make sure your Excel has TOCOL function or use Excel Online
(0:55) Excel.New in Excel Online
(1:05) Unwinding Excel range to 1 column vector
(1:33) SORT and UNIQUE functions
(2:00) COUNTIFS with Dynamic Range as second argument
(2:30) Many names for # symbol
(2:51) Mention video 2385
(3:00) Wrap up with Wally Continue reading “Excel Count Super Bowl Squares By Name – 2371”
New Excel Feature Annoying Half Of All Excellers #shorts
Why is there a thick dark box around the formula bar in Excel?
Or, have you never noticed it?
It is part of the F6 Loop.
Guy in a Cube answers the web’s most searched questions on Power BI
Let’s see what the most asked questions are on the web about Power BI! Adam looks at google for the questions and then responds. You heard that right! He went to Google.
Power BI forecasting
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane#apply-forecasting
Describing the forecasting models in Power View
https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/
Power BI on a Mac?
https://www.youtube.com/watch?v=qUpqtWEOG40
Understand star schema and the importance for Power BI
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
📢 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: <a href="https://guyinacu.be/courses" Continue reading “Guy in a Cube answers the web’s most searched questions on Power BI”
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