Month: February 2025

Conquer Circular Dependencies: Sort Months Effortlessly in Power BI

Posted on by Annie D

Are month-sorting errors driving you mad? In this video, Patrick lifts the curtain on why your semantic model keeps throwing that frustrating circular dependency error. Watch step by step as he reveals the fix—plus a game-changing tip on heading off these issues upstream in Power Query or even at the data source. It’s time to banish those Power BI sorting nightmares and reclaim your data sanity once and for all!

Demo File:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250227%20-%20Month%20will%20not%20sort.zip

📢 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 “Conquer Circular Dependencies: Sort Months Effortlessly in Power BI” →

AI Doesn’t Know This: Best Solution for Excel Table Running Count Error! #Short Excel Trick 63

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch11/ExcelShorst63.xlsx
Learn how to create a simple and easy running count formula in an Excel Table. ROWS Functions with special trick.

Learn #excel #excelformulas #excelfunctions #Short #excelisfun #microsoft #datamodeling #dataanalysis #office365 #office365training

How I Fixed 1000+ Power BI Comments in ONE Day!

Posted on by Annie D

Join Patrick as he shares how he tackled some Power BI questions! These honestly answer thousands of questions we get every day. Following best practices solves so many head-aches!

Demo files:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250226%20-%20Star%20Schema.zip

📢 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 Continue reading “How I Fixed 1000+ Power BI Comments in ONE Day!” →

BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1870-1871.xlsx
Learn how to lookup a value in a rectangle range and return the row or column header with the best and easiest formula ever!!! I did a video 7 years ago (EMT 1426) and the formula was much harder. But now with MS 365 Excel: WOW!!! Everything is so much easier : ) Thanks to ExcelLambda from YouTube for the rad formulas!
Topics:
1. (00:00) Introduction.
2. (00:54) FILTER & BYCOL functions with the Eta Lambda OR Function to create lookup formula that returns column header (Sales Team / Sales Rep Lookup Table example).
3. (02:49) IFS & Continue reading “BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871” →

We’re Going to Try to Automate VBA Coding With AutoVBA!

Posted on by Annie D

***** Video Details *****
In this episode, we explore the power of AI-driven application development and how it’s unlocking new automation possibilities. Learn about AutoVBA, a VBA automation app designed to generate and manage complex code effortlessly, reducing manual work. From AI-enhanced user experiences to solving complex logic dependencies, these projects showcase the incredible potential of AI-first development. As AI continues to evolve, so do the opportunities to build smarter, faster, and more intuitive applications. Tune in to see what’s possible!

***** Related Links *****
https://lovable.dev/
https://supabase.com/

***** Learning with Enterprise DNA *****
FREE Courses – <a href="https://bit.ly/45fu3tw" Continue reading “We’re Going to Try to Automate VBA Coding With AutoVBA!” →

Excel’s WRAPCOLS Array Function to Undo Table Into a Specified # of Columns. #Short Excel Trick #62

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch11/ExcelShort60-62.xlsx
Learn how to use the WRAPCOLS function to take a proper table and move the data into a specified number of columns (how many items encountered in column must be moved to each new column..

Learn #excel #excelformulas #excelfunctions #Short #excelisfun #microsoft #datamodeling #dataanalysis #office365 #office365training

GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1870-1871.xlsx
Learn how to use the GROUPBY function with the eta lambda function COUNTA and PERCENTOF to create frequency distribution that works with text data. Create a count column and a % of Column Total Column with the GROUPBY Function.
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction.
2. (00:21) PivotTables vs. GROUPBY or PIVOTBY Function
3. (00:57) First attempt at using GROUPBY Function. See functions GROUPBY, HSTACK, COUNT and PERCENTOF.
4. (02:00) Why PivotTable correctly calculates % of Column Total for Text Data
5. (02:29) Algorithm for PERCENTOF Function and how it is different than a PivotTable % of Continue reading “GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870” →

No More VBA! Amazing WRAPROWS Function Converts Column of Records to Table. #Short Excel Trick 61

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch11/ExcelShort60-62.xlsx
Learn how to convert a column of records to a proper table without VBA, using the Microsoft 365 Excel Array Function, WRAPROWS function. See Two Examples.

Learn #excel #excelformulas #excelfunctions #Short #array #dynamicspill #arrayformulas #office365 #office365training #data #datascience #database #datamodelling #tablestructure #table #peopertable #microsoft Excel #excelisfun #wraprows

Extracting Your BIM File and Using AI Extensively for Assistance

Posted on by Annie D

***** Video Details *****
Did you know you can extract metadata from Power BI reports and use AI to enhance your data models? In this episode, we walk you through how to convert a PBIX file into a project file, revealing key metadata, DAX formulas, and Power Query details. Using AI tools like ChatGPT and DeepSeek, we explore ways to optimize data models, generate new DAX measures, and automate analytical insights. Whether you’re working with SQL, M code, or Power BI reports, AI can transform the way you analyze and improve data. Don’t miss this game-changing workflow that bridges Power BI, Continue reading “Extracting Your BIM File and Using AI Extensively for Assistance” →

Best Formula for % Change (Daily Stock Returns). #Short Excel Trick 60

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch11/ ExcelShorst60-62.xlsx
Learn how to create a dynamic spilled array formula to calculate the daily returned for three columns of stocks. Learn that the easiest formula for 5 change is End/Begin – 1 , not (End – Begin)/Begin.

Learn #excel #excelformulas #excelfunctions #Short #365excel #office365 #office365training #excelfinance #percentage #dailyreturns #excelisfun #change #changeyourlife

How to Setup a New Application Ultra Fast Using Cursor + Copycoder

Posted on by Annie D

***** Video Details *****
AI is changing the game for developers! In this episode, we explore Copycoder & Cursor, two cutting-edge AI tools revolutionizing software development. Watch as we take a screenshot of a design and turn it into a fully structured app—automatically. From frontend layouts to backend setup with Supabase, AI is making full-stack development faster, easier, and more accessible than ever. We also dive into authentication automation, project structuring, and the rise of AI-powered development ecosystems. What used to take hours can now be done in minutes—so is this the future of coding? Tune in to see AI in Continue reading “How to Setup a New Application Ultra Fast Using Cursor + Copycoder” →