Category: Power Query

Getting started with Visual Calcs in Power BI

Posted on by Annie D

It’s been a long time coming but Visual Calculations within Power BI are here!!! Jay joins us to get us started on using Visual Calcs within our reports.

Share your thoughts on visual calculations (preview)
https://aka.ms/visual-calculations-feedback

Using visual calculations (preview)
https://learn.microsoft.com/power-bi/transform-model/desktop-visual-calculations-overview

Jeroen (Jay) ter Heerdt
https://twitter.com/JayPowerBI
https://www.linkedin.com/in/jeroenterheerdt/
https://www.dutchdatadude.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
— <a href="http://twitter.com/awsaxton" Continue reading “Getting started with Visual Calcs in Power BI” →

Uncovering OneLake’s Secrets with Delta Analyzer in Microsoft Fabric

Posted on by Annie D

You need to make sure your delta files in OneLake are healthy! Phil has you covered with a Delta Analyzer notebook that you can use within Microsoft Fabric to check on things.

Delta Analyzer
https://aka.ms/deltaanalyzer

Phil Seamark
https://twitter.com/PhilSeamark
https://www.linkedin.com/in/seamark/
https://dax.tips

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

#PowerBI #GuyInACube

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Mar 2, 2024) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “🔴 Microsoft Fabric / Power BI Q&A – LIVE (Mar 2, 2024) (Member Chat 2nd Half)” →

All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric

Posted on by Annie D

Who needs NOCODE? Patrick takes you on a journey where you can extract ZIP files within a Notebook in Microsoft Fabric. Also found a very cool feature in Notebooks!

📢 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 href="https://guyinacube.com/tools/" Continue reading “All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric” →

NO CODE extract ZIP files with Pipelines in Microsoft Fabric

Posted on by Annie D

Need to extract ZIP files and don’t want to write code? Adam walks you through how you can do this with Pipelines and dataflows within Microsoft Fabric. A NO CODE approach!

📢 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 “NO CODE extract ZIP files with Pipelines in Microsoft Fabric” →

Excel Formulas to convert to Upper, Lower, or Proper Case #excel

Posted on by Annie D

Microsoft Excel Tutorial: Upper, Lower, Proper Case with a Formula in Excel.

In this tutorial, learn how to effortlessly convert text to upper, lower, or proper case using Excel formulas. Discover three essential functions that streamline the case conversion process. Whether you’re transforming text to lowercase with LOWER(A2), uppercase with UPPER(B2), or proper case with PROPER(C2), these functions have you covered. But beware of nuances – even PROPER doesn’t always nail the interior ‘C’ in McCartney, necessitating manual adjustments.
But what about real-world scenarios where your data extends beyond the conversion zone? Fear not! We’ll guide you through inserting a temporary column Continue reading “Excel Formulas to convert to Upper, Lower, or Proper Case #excel” →

Excel Number of Days To End of Year for Reaching a Goal

Posted on by Annie D

Microsoft Excel Tutorial: Calculate Number of Days to End of Year for Reaching a Goal.

Thanks to Kikas for this idea!

Unlock the secrets of Excel productivity with our latest tutorial! In this comprehensive guide, we unravel the complexities of Excel calculations to streamline your task management process. Are you struggling to determine the number of items you need to complete daily to meet your year-end goals? Look no further! Speaker 1 expertly guides you through the process, breaking down intricate formulas into simple, actionable steps.

Discover how to calculate the precise number of items you need to tackle each day to ensure Continue reading “Excel Number of Days To End of Year for Reaching a Goal” →

Excel Join First Name and Last Name as Proper Case

Posted on by Annie D

Microsoft Excel Tutorial: Join First Name and Last Name as Proper Case in Excel.

Buy my new book here: https://www.mrexcel.com/products/latest/

Welcome back to another Excel tutorial! Today, we’re diving into the efficient method of joining first names and last names in your spreadsheet while ensuring they are displayed in proper case. Join MrExcel as he walks you through the simple yet powerful techniques to achieve this task seamlessly.

Key Points Covered:
• Learn the fundamental formula using the CONCATENATE operator to merge first names and last names from different cells.
• Discover how to convert the combined text into proper case using Continue reading “Excel Join First Name and Last Name as Proper Case” →

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Feb 24, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “🔴 Microsoft Fabric / Power BI Q&A – LIVE (Feb 24, 2023) (Member Chat 2nd Half)” →

Excel Fast Way to Copy Formula to Bottom of Data in Five Keystrokes #excel

Posted on by Annie D

Microsoft Excel Tutorial: Fast Way to Copy Formula to Bottom of Data in Five Keystrokes.

This tip is from the book MrExcel 2024 – Igniting Excel. Buy the book here: https://www.mrexcel.com/products/latest/

Check out this video to learn how to copy formulas to the bottom of your data in Excel using just five keystrokes! 🚀
If you’re a fan of keyboard shortcuts, this trick will save you tons of time. Here’s a quick rundown:
1. Left arrow to B2.
2. Ctrl + down arrow.
3. Right arrow.
4. Ctrl + Shift + up arrow to select to the top.
5. And the magic: Ctrl + D Continue reading “Excel Fast Way to Copy Formula to Bottom of Data in Five Keystrokes #excel” →

Creating your first EVENTSTREAM in Microsoft Fabric

Posted on by Annie D

Join Patrick as he explores Real-Time Analytics (RTA) in Microsoft Fabric by creating an event stream into a KQL Database. It only takes a few clicks!

What is RTA:
https://learn.microsoft.com/en-us/fabric/real-time-analytics/overview

Event Streams overview:
https://learn.microsoft.com/en-us/fabric/real-time-analytics/event-streams/overview

📢 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 “Creating your first EVENTSTREAM in Microsoft Fabric” →