Download Excel File: https://excelisfun.net/files/EMT1852.xlsx
Learn the old way and the new way to append tables in Excel.
Topics:
1. (00:00) Introduction
2. (00:10) Old Method
3. (00:17) New Method with VSTACK
4. (00:37) Summary
5. (00:53) Closing, Video Links
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #VSTACK
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 17, 2023) (Member Chat 2nd Half)”
Microsoft Excel Tutorial: Excel Keeps Inserting Old Formula – How to Fix It!
Every time that Tori adds a new row to her Excel table, four columns auto-fill formulas from years ago.
Oh my gosh. Ever had a crazy frustrating problem with Excel? In this video, we tackle Tori’s Excel nightmare head-on. Tori’s adding new rows to her table, only to find four columns haunted by formulas from three years ago! What gives?
Hey there! If you’re facing Excel woes like Tori, hit that Like button below to help more folks find this solution-packed video – thanks for the support!
Picture this: Tori’s table Continue reading “Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640”
Download Excel File: https://excelisfun.net/files/EMT1851.xlsx
Celebrate Mike Girvin’s excelisfun 16 Years at YouTube Birthday Party!!! Learn Power Query M Code tricks too.
Topics:
1. (00:00) Introduction
2. (00:01) Thanks you for 16 years!!!!
3. (00:25) Alphanumeric Min and Max. List.Min on Text items, Words!?!?! Yes!
4. (01:37) Group By Can Insensitive!?!? Yes!!! With Table.GroupBy function
5. (02:32) Closing, Video Links
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #powerquery, #mcode
Comparer.Ordinal, Comparer.OrdinalIgnoreCase
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 “REPLAY Microsoft Fabric/Power BI Q&A – LIVE (Sept 2, 2023)”
Conference season is in full swing, and you have an opportunity to come meet Adam and Patrick in person! From Microsoft Power Platform Conference, to dataMinds Connect, PASS Data Community Summit and the Microsoft Data & AI conferences, now is a great time to take part in the community.
We will be bringing Microsoft Fabric and Power BI to the community!
Microsoft Power Platform Conference
https://powerplatformconf.com/
dataMinds Connect
https://datamindsconnect.be/
PASS Data Community Summit
https://passdatacommunitysummit.com/
Pre-Con: https://passdatacommunitysummit.com/sessions/1970
Microsoft Data & AI Conferenct
https://msdataaiconf.com/
Pre-Con: https://msdataaiconf.com/#!/workshop/Power%20BI%20Hidden%20Gems/6191
📢 Become a member: https://guyinacu.be/membership
*******************
Want to Continue reading “The secret whereabouts of Adam & Patrick revealed!”
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 “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Oct 14, 2023)”
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 “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Oct 21, 2023)”
Prioritizing questions around DAX Studio 3, 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (October 28, 2023)”
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 “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Dec 2, 2023)”
Want to secure your data in Microsoft Fabric? Adam walks you through different options and layers to control access and prevent people from looking at data they shouldn’t for your lakehouse or warehouse!
Roles in workspaces in Microsoft Fabric
https://learn.microsoft.com/fabric/get-started/roles-workspaces
Row-level security in Fabric data warehousing
https://learn.microsoft.com/fabric/data-warehouse/row-level-security
Row-level security
https://learn.microsoft.com/sql/relational-databases/security/row-level-security?view=sql-server-ver16
Column-level security in Fabric data warehousing
https://learn.microsoft.com/fabric/data-warehouse/column-level-security
How lakehouse sharing works
https://learn.microsoft.com/fabric/data-engineering/lakehouse-sharing
Share your warehouse and manage permissions
https://learn.microsoft.com/fabric/data-warehouse/share-warehouse-manage-permissions
📢 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 “Control ACCESS to your Microsoft Fabric Lakehouse or Warehouse”
Wait!?! I need to adjust some properties in my Power BI semantic model, but I can’t edit it? What’s going on? Patrick shows you what you need to know!
📢 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 “Why can’t I edit my Power BI semantic model?”