Category: Power Query

Where do you add that new column in any analytics tool?

Posted on by Annie D

You need to add a new column in Power BI – or any business analytics tool. Where do you add the column? Is there a cost to that? Matthew Roche explains his thoughts on his maxim that has everyone talking!

Connect with Matthew Roche
Twitter: https://twitter.com/SQLAllFather
LinkedIn: https://www.linkedin.com/in/matthewroche/
Blog: https://ssbipolar.com/

Roche’s Maxim of Data Transformation
https://ssbipolar.com/2021/05/31/roches-maxim/

Matthew’s career journey:
The Unplanned Career – 25 years in tech without a 3-year plan
https://www.youtube.com/watch?v=CKOAIp9TTvQ

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses Continue reading “Where do you add that new column in any analytics tool?” →

Save early, save often in Azure Synapse Studio

Posted on by Annie D

We’ve all been there. You are in your zone and working hard. Then something happens and you lose everything! Patrick talks about ways to maintain your hard work in Azure Synapse Studio.

📢 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***
🛠 Check out my Tools page Continue reading “Save early, save often in Azure Synapse Studio” →

Is Excel DATEDIF Gone from Excel? #shorts

Posted on by Annie D

C. R. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. Luckily, it is still there, but you have to know the arguments because Excel won’t provide any guidance.

This video answers these questions:
is datedif still in excel
is datedif in excel 2016
why does datedif not work in excel
does datedif still work
can’t find datedif in excel
does datedif still work
datedif how to use
how excel datedif works
how to add datedif function in excel
how to get datedif in excel
how to enable datedif function in excel
what replaced datedif in excel
how to use datedif

🔴 Power BI tips from the Pros – LIVE w/ Kasper de Jonge (Oct 1, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI! With special guest, Kasper de Jonge!

Connect with Kasper:
Website: https://www.kasperonbi.com/
YouTube: https://www.youtube.com/channel/UC40_DLjKbvxkhMc7N4UevkA
Twitter: https://twitter.com/kjonge

📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE w/ Kasper de Jonge (Oct 1, 2022) (Member Chat 2nd Half)” →

Do you even need to use Power Query Functions?

Posted on by Annie D

You can do amazing things in Power Query! Maybe you think to create a function. But do you really need a function for that? Or is it over complicating things?

📢 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***
🛠 Check out my Tools page – <a Continue reading “Do you even need to use Power Query Functions?” →

Rounding out the lakehouse with the GOLD layer in Azure Synapse

Posted on by Annie D

We are completing the journey of our lakehouse with our GOLD layer in Azure Synapse. This gives you the table structures you need to start building those amazing reports in Power BI!

Stijn Wynants
https://twitter.com/SQLStijn

📢 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***
🛠 Check Continue reading “Rounding out the lakehouse with the GOLD layer in Azure Synapse” →

Excel Habit Tracker Count Current Streak – 2517

Posted on by Annie D

How to calculate the current streak in a habit tracker.
Amreen is building a habit tracker in Excel. For each goal, he wants to report the current streak.
I show how to use XMATCH to solve this problem.

Table of Contents()
(0:00) The goal
(0:40) XMATCH formula for last 1
(1:08) Last zero
(1:29) No streak?
(1:45) How long is streak?
(2:30) Episode 735 for longest streak
(3:05) Converting to checkmarks
(4:32) Colors in Excel number format

Answering your questions about the new App Experience!

Posted on by Annie D

So many questions about the new Power BI App experience! Going through a few of the themes that came out of last week’s video to get you some answers! What other questions do you have that weren’t covered?

📢 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/
— rel=”nofollow”>https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Apps #GuyInACube

Excel VBA User Defined Function To Generate A Dynamic Array – 2516

Posted on by Annie D

Can Excel VBA return a dynamic array from a user defined function to the grid?
Can you repeat each cell in column A based on the number in column B?

Check out the amazing answers from Smozgur and XLLambda here:
https://www.mrexcel.com/board/threads/repeatbynumber.1216836/

Table of Contents
(0:00) Two titles
(1:11) Using VBA
(2:05) How many cells to return
(2:50) Building the array
(3:22) Return array to grid
(4:00) Using Hash array operator

Excel Insert Blank Row After Every Two Data Rows #Shorts

Posted on by Annie D

LC has 4000 rows of Excel data. After every two rows, he wants to insert a blank row. How can he quickly insert 2000 blank rows in the data? My solution today involves a formula to create alternating cells with text and numbers. Then Home, Find & Select, Go To Special. Select all Formula cells that result in Text. This selects every other row. You can then Insert Sheet Rows and you are done in less than 60 seconds.

Storytelling with Power BI and PowerPoint

Posted on by Annie D

Give up those static images of your reports in PowerPoint! Learn how to integrate your Power BI report to help tell your story directly within PowerPoint!

Tell a story with your data. Announcing the all-new Power BI integration for PowerPoint
https://powerbi.microsoft.com/blog/tell-a-story-with-your-data-announcing-the-all-new-power-bi-integration-for-powerpoint/

About Power BI in PowerPoint
https://docs.microsoft.com/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-about

📢 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
— Continue reading “Storytelling with Power BI and PowerPoint” →

Excel FILTER To 2 conditions with LEFT #Shorts

Posted on by Annie D

Keith wants to use the Excel FILTER function to get all names where two conditions are true: Status is A and the Project does not start with 22-05. This video shows how to combine 2 conditions in an Excel FILTER formula.

excel filter function
why excel filter not working
excel can you filter columns
excel can you filter with LEFT
excel can you filter to two conditions