Brand new in Excel Insiders Beta:
A chart can be based on an entire dynamic array in Excel.
In this first iteration, the chart has to point to the entire array. If you have columns in your array that you don’t want to chart, you should use =CHOOSECOLS to get a smaller subset of the array for charting.
Join us live as we talk Power BI from the Power Platform Conference in Orlando, Florida! We are bound to have a special guest or two and hopefully a live audience.
Power Platform Conference: https://powerplatformconf.com
📢 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/
— https://guyinacube.com
***Gear***
🛠 Continue reading “🔴 Power Platform Conference LIVE!!! (Sept 21, 2022)”
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 (Sept 17, 2022) (Member Chat 2nd Half)”
This has been a feature that has been asked for long time! The ability to control who can see what content within a published Power BI App! You can now serve up multiple audiences within a single app.
Announcing Public Preview of Multiple Audiences for Power BI Apps
https://powerbi.microsoft.com/en-us/blog/announcing-public-preview-of-multiple-audiences-for-power-bi-apps/
Publish an app in Power BI
https://docs.microsoft.com/power-bi/collaborate-share/service-create-distribute-apps?source=recommendations
📢 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!
*******************
— rel=”nofollow”>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 #Apps #GuyInACube
From Power BI Desktop, to Task Manager, to different spots in the Power BI service – why are the sizes different? What’s going on? How can you tell what the real size is? Well, it depends! Marco Russo joins Patrick to explain.
📢 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
— rel=”nofollow”>https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #DataModel #GuyInACube
Excel IF Contains
Excel IF cell contains text
Excel IF contains
excel like wildcard
excel wildcard
excel like wildcard if
How can you test which cells in Excel contain text? Can you use an IF statement in Excel to find which cells contain certain text?
This video looks at COUNTIF, FIND, SEARCH, LOWER, SIGN, ISNUMBER, IFERROR functions.
Table of Contents
(0:00) Question
(0:22) Check for equality
(0:41) Wildcards fail in IF
(1:05) Using COUNTIF with wildcard
(1:39) Using FIND in Excel
(2:23) Adding SIGN, IFERROR, LOWER
(2:59) Using SEARCH in Excel
(3:25) Using ISNUMBER with SEARCH
(4:22) Excel IF contains solution
(4:44) Finding Contains using Filter
(5:11) Nancy Faust
Prioritizing questions around optimization, performance, DAX, data modeling, processing, etc…
📢 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
Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to Continue reading “REPLAY Power BI Optimization Q&A – LIVE w/ Marco Russo (Aug 5, 2022)”
excel formula not calculating
why excel formula is not calculating
when excel shows formula not result
when excel doesn’t calculate a formula
When excel shows the formula instead of the result
Table of Contents
(0:00) Excel shows formula not result
(0:04) Cell formatted as Text
(0:23) in Show Formulas mode
Four answers today:
Excel remove duplicates without shifting
Keep Duplicates Remove Everything Else
Which Row does Excel Keep during Remove Duplicates
Excel Get Duplicates Back
Formula to Remove Duplicates in Excel using UNIQUE and SORT functions
FILTER to keep only certain columns
Ctrl+z or Alt+Backspace to Undo
Topics discussed in this video include:
excel remove duplicates without shifting
excel only include duplicates
excel keep duplicates remove unique
excel keep duplicates remove everything else
excel keep duplicates
excel duplicates keep
how to get duplicates back in excel
can you add duplicates back in excel
excel list duplicates between two columns
excel remove duplicates using formula
excel duplicates remove formula
excel duplicates formula
excel is duplicate formula
in excel duplicate formula
excel no duplicates formula
excel Continue reading “Excel KEEP Duplicates Delete Everything Else – 2513”
5 Excel topics in 55 seconds. In this video, I answer five common questions about duplicates in Excel. This video will address:
excel find duplicates without deleting
can excel find duplicates
excel duplicates find
can i find duplicates in excel
excel remove duplicates without losing data
excel find duplicates in a list
can excel highlight duplicates
excel duplicates highlight
can excel look for duplicates
can excel pick up duplicates
excel recognize duplicates
how to see if duplicates in excel
how to see duplicates in excel column
excel check for duplicates in a list
excel duplicate check
excel check if duplicates in range
excel for duplicates
excel duplicates in one column
excel duplicates color
excel and duplicates
excel duplicates conditional formatting
excel duplicate Continue reading “Excel Duplicates – 5 Answers in 55 Seconds – #shorts”
The base tooltips in Power BI are fine. But are you overusing them? Adding everything to them in your visuals? Adam gives you some things to think about with your tooltips!
Create tooltips based on report pages
https://docs.microsoft.com/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop
📢 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 “Are you thinking about your tooltips in Power BI?”
Mohammad asks: How do we vlookup part of a cell in part of another cell. For example, find “bank of america” in “you have received money from bank of america account”. This video shows how to solve this with VLOOKUP, XLOOKUP, and SUMIFS.
Topics here:
wildcard excel lookup
wildcards in excel formula
how to use excel wildcards
excel how to search wildcards
what are excel wildcards
wildcards excel search
excel wildcard search in formula
excel wildcard search not working
excel wildcards search
microsoft excel wildcards
microsoft excel wildcard in formula
wildcard not working excel
excel wildcards does not work
excel using wildcards
excel wildcard for text
excel wildcards vlookup
excel wildcard xlookup
excel wildcard zero or more characters
excel wildcard Continue reading “Wildcards in Excel VLOOKUP XLOOKUP and SUMIFS – 2512”