Category: Power Query

Talking DATA end to end with Buck Woody

Posted on by Annie D

Where does your data come from? What do you need to consider with your data? Buck Woody explored the world of data and how services like Azure Synapse Analytics and Power BI can help you in your journey!

Connect with Buck:
https://twitter.com/BuckWoodyMSFT
https://www.linkedin.com/in/buckwoody/

📢 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/

#AzureSynapse #PowerBI #GuyInACube

Excel Dynamic Charts Based On Dynamic Arrays – 2515

Posted on by Annie D

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.

🔴 Power Platform Conference LIVE!!! (Sept 21, 2022)

Posted on by Annie D

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)” →

🔴 Power BI tips from the Pros – LIVE (Sept 17, 2022) (Member Chat 2nd Half)

Posted on by Annie D

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)” →

Power BI Apps for multiple audiences has arrived!

Posted on by Annie D

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

What’s the real size of your data model in Power BI?

Posted on by Annie D

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 – 2514

Posted on by Annie D

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

REPLAY Power BI Optimization Q&A – LIVE w/ Marco Russo (Aug 5, 2022)

Posted on by Annie D

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)” →

When Excel Shows Formula Not The Result #shorts

Posted on by Annie D

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

Excel KEEP Duplicates Delete Everything Else – 2513

Posted on by Annie D

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

Excel Duplicates – 5 Answers in 55 Seconds – #shorts

Posted on by Annie D

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

Are you thinking about your tooltips in Power BI?

Posted on by Annie D

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