Smart Way to Combine CSVs with Inconsistent Headers in Power Query Goodly 2026-09-19 | Smart Way to Combine CSVs with Inconsistent Headers in Power Query
Copy Formatting in Power BI in 2 Seconds Goodly 2025-09-13 | Use the Format Painter to quickly copy formatting between visuals in Power BI. Click the formatted object, select the Format Painter icon, then click any other visual to apply the same style.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
2 Simple Excel Tricks to Save Time Instantly Goodly 2025-09-11 | Learn two quick Excel tricks that make your work easier. First, use Alt + H + F to clear all formatting from pasted data. Second, set up AutoCorrect shortcuts to expand abbreviations into full text automatically. ===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
What Is DAX Query View? 5 Tricks You Should Know Goodly 2025-09-10 | In this video, I will explain what DAX Query View is in Power BI, how to enable it, and why it’s such a useful hidden feature. DAX Query View works like a sandbox where you can safely test calculations, define temporary measures and columns, and evaluate them without changing your actual model.You’ll also see how to commit new measures, edit existing ones, explore measure dependencies, and even run multiple EVALUATE statements in a single query. These practical tricks will help you get the most out of DAX Query View and make your DAX writing and debugging a lot easier.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️- https://goodly.co.in/dax-query-view-tricks===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Show Missing Months in Pivot Tables (Even with No Data) Goodly 2025-09-08 | Make your Excel pivot tables display all months or categories even when data is missing. Right-click the field, choose Field Settings, go to Layout and Print, and select Show items with no data. This ensures gaps like zero-sale months appear blank instead of hiding, keeping your reports accurate and complete.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Never Manually Calculate Age Again (Do This Instead) Goodly 2025-09-06 | Learn how to quickly calculate age in years and months directly in Power Query. Using the dedicated age function, you can automate age calculations from date of birth columns without complex formulas. ===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Genius Visual Calculation Tricks in Power BI Goodly 2025-09-03 | Visual Calculations in Power BI have been around for a while, but there’s a lot you can do beyond the default options in the drop-down. In this video, I’ll show you some really useful tricks with visual calculations, e.g. adding row numbers, resetting them by fields, handling totals with ISATLEVEL, creating moving averages, using the ROWS operator, and pulling first or last values. You’ll learn how visual calculations can solve common reporting problems in a much simpler way.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://goodly.co.in/visual-calculations-tricks-in-power-bi/===== Chapters =====0:00 - Intro0:25 - Add Row Numbers to Matrix Visual4:26 - Handle Calculation Levels5:30 - Moving Average Calculation9:31 - The Rows Operator14:30 - Finding the First and Last Values===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Do This to Your Tables Before You Share Any Report 🔥 Goodly 2025-09-03 | Most Power BI tables look cluttered and boring by default. But with three simple changes, you can make them clean and professional. First, switch to a minimal style preset to remove unnecessary lines and shading. Second, increase the padding between rows to give your data room to breathe. Third, add subtle conditional formatting like light data bars to highlight key numbers without overwhelming the eye.These small adjustments take seconds but make a huge difference in how your reports are perceived. ===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Fix Power BI Relationships in 2 Steps (No More Errors) Goodly 2025-09-01 | Power BI relationships fail for two common reasons. First, the column you’re linking can’t have blank values. Second, the "one" side of the relationship must contain unique values—no duplicates. Break either rule, and Power BI won’t let you create the relationship.Fix this by cleaning your data first. Remove blanks and ensure your lookup column has unique entries. Once you do, building one-to-many relationships becomes effortless.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Power BI’s Hidden Click-to-Edit Feature 🤩 Goodly 2025-08-30 | Editing charts in Power BI doesn’t have to mean digging through menus. You can click directly on chart elements to delete, format, or tweak them. Want to remove a label? Click it and hit Delete. Need to edit the title? Just click and type. It’s that simple.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Power BI’s Hidden Gem - Visual Calculations Goodly 2025-08-28 | Creating running totals in Power BI is easier than you think. With visual calculations, you can generate a running sum directly in your visual without writing complex DAX. Just click the ellipsis menu, select "New Visual Calculation," and choose "Running Sum." Then, pick the field you want to calculate, like Total Sales and Power BI does the rest.This feature is perfect for quick insights without digging into formulas. It works even with text-based categories, not just dates or numbers.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
I Bet You Didn’t Know Power Query Could Do This (7 Tricks) Goodly 2025-08-27 | Power Query isn’t just about simple transformations. Once you start exploring, you’ll find some hidden tricks that make your queries shorter, cleaner, and way more fun to work with.In this video, I’m sharing 7 of my favourite Power Query tricks, a mix of practical ones you’ll use every day and a few clever ones you probably haven’t seen before. Some of them save you time, some make your queries more dynamic, and a couple are just plain cool (my favourite is trick #7).If you enjoy these examples and want to go deeper into M language, you can check out my structured courses here - https://products.goodly.co.in/learn-m-powerquery/?===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://goodly.co.in/i-bet-you-didnt-know-power-query-could-do-this-7-tricks/===== CHAPTERS =====00:00 - Intro0:18 - Trick 13:17 - Trick 26:51 - Trick 39:29 - Trick 411:11 - Trick 514:02 - Trick 617:11 - Trick 7===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Arrange Your Visuals in SECONDS with this Simple Trick 😎 Goodly 2025-08-25 | Manually aligning visuals in Power BI is a waste of time. Instead, use the built-in alignment tools. Select all the objects you want to organize, go to the Format tab, and choose Align Top to line them up perfectly. Then, use Distribute Horizontally to space them evenly.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
How to Style visuals Faster in Power BI Goodly 2025-08-23 | Formatting visuals in Power BI doesn’t have to be slow. Use the Format Painter to quickly copy styles from one visual to another. Just click the formatted visual, select the Format Painter icon, and click the visual you want to update. It instantly applies the same colors, borders, fonts, and more.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
The One Thing That Makes Charts Instantly Better Goodly 2025-08-21 | Most people use boring chart titles like "Sales by Region" or "Yearly Growth." But the best charts tell a story with their titles. Instead of just describing what the chart shows, try writing a title that highlights the most important insight - like "30ml Protein Hair Oil Grew 2100% Last Year." This grabs attention and guides people to what matters.Consulting firms like McKinsey and BCG use this trick all the time. It turns basic charts into something people actually remember and talk about.Try rewriting your next chart title to focus on the key takeaway - not just the topic. You’ll be surprised how much more engaging it becomes.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Power BI Lookup Tricks You’ll Wish You Knew Sooner Goodly 2025-08-20 | If you’re moving from Excel to Power BI, one of the first things you’ll notice is that there’s no VLOOKUP function. But the good news? Power BI gives you even more powerful ways to handle lookups.In this video, I’ll show you five different lookup tricks in Power BI that go way beyond Excel’s VLOOKUP or XLOOKUP. You’ll learn how to -- Use relationships as virtual lookups- Apply the RELATED function- Work with RELATEDTABLE to handle multiple matching rows- Use LOOKUPVALUE when you don’t have a relationship- Apply CROSSFILTER for tricky reverse lookup scenariosBy the end, you’ll know how to confidently replace VLOOKUP in Power BI and solve real-world problems with cleaner, smarter DAX.If you’d like to learn DAX and data modelling, Power Query, and M language in a structured way, check out my courses here - https://goodly.co.in/products/===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://www.goodly.co.in/lookup-tricks-in-Power-BI/===== CHAPTERS =====00:00 - Intro00:30 - Trick 105:01 - Trick 208:22 - Trick 312:59 - Trick 416:10 - Trick 5===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Stop Basic Trimming – Use This Advanced PQ Hack 😎 Goodly 2025-08-18 | Power Query's Text.Trim() function makes cleaning text data effortless. Just specify which characters to remove - like colons, commas or underscores and it automatically strips them from your text.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Stop Struggling with Dates in Power BI - Use This Method Goodly 2025-08-16 | Building a proper date table is essential for Power BI reports. This video shows how to create one quickly using CALENDARAUTO() to generate dates, then adding formatted month, quarter, year, and sort columns. The result works perfectly with time intelligence functions and keeps your dates organized correctly.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
The Fastest Way to Align Visuals in Power BI Goodly 2025-08-14 | Moving visuals in Power BI? Instead of dragging or using arrow keys alone, hold Shift + Arrow keys to move objects faster and in bigger increments.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Build This Stunning Top N Matrix in Power BI 😍 Goodly 2025-08-13 | youtu.be/yAlKFLXoyp0?si=CDg4bN_IcgsMB4fXyoutu.be/7TiyGJPFXsk?si=KOrGEF0R11B-9shhIn this video, I’ll show you how to create a fully dynamic Top N visual in Power BI, where you can display the top products (or any category you choose) and roll everything else into an “Others” category. You’ll see how to make it work with a slicer so users can pick the number of top items they want to see, and the visual updates instantly without any hardcoding.I’ll cover techniques like using TOPN, KEEPFILTERS, dynamic measures, and handling totals so you can display Top N totals, Other totals, and overall totals all in the same visual. I’ll also share some formatting tricks to make your table look cleaner and more like a polished Excel report, including conditional formatting bars and blank row spacing.By the end, you’ll know how to build a Top N visual that’s not only dynamic but also flexible enough to handle real-world reporting needs in Power BI.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the Power BI File ⬇️ - https://www.goodly.co.in/how-to-make-a-dynamic-top-n-others-matrix-in-power-bi===== CHAPTERS =====00:00 - Intro00:30 - Stage 110:32 - Stage 216:03 - Stage 320:31 - Stage 4===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
❌ STOP ❌ Recreating the Same Power Query Steps Over and Over Goodly 2025-08-11 | Stop rebuilding the same transformations in every Power Query. Extract steps from one query and reuse them in others – this keeps your data consistent and saves hours of repetitive work.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Stop Adding Columns One by One – Try This Goodly 2025-08-09 | In this video, I’ll show you how to add multiple columns at once in Power Query using a single custom column. Instead of creating columns one by one, use record syntax to define multiple calculations in one step.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
My Favorite Power BI Button 😍 (You’ll Love It Too) Goodly 2025-08-07 | The Navigator button in Power BI creates a clickable page menu automatically. Insert it from the Buttons menu, and it lists all report pages no manual linking required. A quick way to improve report navigation.Subscribe for more Power BI shortcuts.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
5 Advanced Tricks to Unlock Pivot Table Genius Mode Goodly 2025-08-06 | Everyone knows how to build a Pivot Table, but very few know the insane tricks that can make them 10x more powerful. In this video, I’ll show you how to push Pivot Tables beyond their regular limits and solve problems you thought needed manual workarounds.You’ll learn how to do double summarisation (Pivot on top of Pivot), find the top salesperson’s sales and name in a single formula, reshuffle Pivot Table items manually, selectively repeat labels and even create multiple Pivot Table reports on separate sheets in one click. These are the kind of tricks that make people stop and ask, “Wait, how did you do that?”If you're serious about mastering Excel, DAX, Power Query or data modeling, I have structured courses to help you learn these skills step-by-step. Check out my courses here - https://goodly.co.in/products/===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://goodly.co.in/5-simple-tricks-to-unlock-pivot-table-genius-mode/=====Chapters =====00:00 - Intro00:17 - Double Summarization05:30 - Shuffle Values06:19 - Selective Fill Down07:24 - Report Filter Pages08:49 - Show Text as Calculation===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraInstagram - instagram.com/goodlychandeepEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Freeze Visuals Temporarily in Power BI With This Trick Goodly 2025-08-04 | To improve performance in Power BI when working with slow visuals, use the Pause Visuals feature. Enable it in the Optimize tab to stop automatic refreshes when interacting with slicers. Once you’ve made all selections, manually refresh visuals to update them at once.This helps reduce lag in complex reports with heavy calculations or large datasets. A simple way to make filtering smoother without constant reloading.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Stop Showing Raw URLs ❌ Do This Instead ✅ Goodly 2025-08-02 | Here's a simple setting that turns Web URLs into clean, clickable icons, making your reports look polished and professional.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
I Wish I Knew This Power BI Image Trick Sooner 😲 Goodly 2025-07-31 | Learn how to automatically display images from web URLs directly in your Power BI reports. In this video, I will show you the simple process of converting hyperlinks into images. Which you can use in your tables, slicers, and other visuals.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
DAX CALCULATE Explained with 5 Real Examples Goodly 2025-07-30 | youtu.be/Vz-38fJ4asc?si=1wTBdfo-OyKncRi5youtu.be/yAlKFLXoyp0?si=cvvWjlVWX9EczefAyoutu.be/22qKPBy2DF0?si=onVYbm26v3tcn9lgyoutu.be/NkYwwb7I3BY?si=819imwPfzFk5SMi8youtu.be/zInhbElc8xU?si=EyDlKEq9bl0Mn5IqIf you're interested in learning DAX & Data Modelling, Power Query, M language in a structured way, I’ve got some awesome courses for you – https://products.goodly.co.in/The CALCULATE function in DAX can be simple on the surface, but it behaves in very specific ways depending on how you use filters. In this video, I’ll take you through five practical examples that show how CALCULATE actually works, especially when you're dealing with static filters, time-based calculations, alternate relationships and context transition. Along the way, we’ll also look at functions like KEEPFILTERS, SAMEPERIODLASTYEAR, DATESBETWEEN, USERELATIONSHIP and how CALCULATE triggers context transition. If your DAX numbers sometimes don’t make sense or totals look off, chances are CALCULATE is behaving exactly as it should; you just need to know how. Once you get these concepts, you’ll be able to write much cleaner and more reliable measures.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️- https://www.goodly.co.in/dax-calculate-explained-with-5-real-examples===== CHAPTERS =====00:00 Intro00:28 Static Filters04:17 Time Based Filters 10:19 Layering Filters13:59 Switching Relationships16:08 Context Transition===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Display Formulas as Text with This Excel Trick Goodly 2025-07-28 | Ever wish you could see your Excel formulas without constantly pressing F2? The FORMULATEXT function solves this problem by displaying formulas right in your cells as text!Just type =FORMULATEXT(A1) (replace A1 with your formula cell) and Excel will show the actual formula. No more switching to edit mode - your formulas stay visible all the time.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Find Columns in Power Query in 2 Seconds Goodly 2025-07-26 | Working with wide tables in Power Query? Instead of scrolling endlessly to find the right column, use the Ctrl + G shortcut to jump directly to any column in seconds.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Create Powerful Mini Charts in Excel Instantly Goodly 2025-07-24 | Tired of bulky charts taking up space in Excel? Sparklines solve that problem—they’re tiny, dynamic charts that fit right inside a single cell.In seconds, you’ve got a visual trend tracker that updates automatically. Perfect for dashboards, financial reports, or any data-heavy sheet.Try it out and let me know—what’s your favorite Excel visualization trick? Subscribe for more quick Excel hacks!===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
8 Genius Hacks to CREATE BEAUTIFUL TABLE VISUALS in Power BI Goodly 2025-07-23 | youtu.be/xVLi31mOxeoyoutu.be/J6yxJ2uELxQyoutu.be/Gc8B-wLIPt0You and I both know tables and matrix visuals are the backbone of Power BI reports, but they often look dull compared to flashy charts. What if you could make your tables just as impressive and professional? In this video, I’ll show you exactly how to elevate your table visuals from basic to boardroom-ready.We'll start with simple fixes like switching from compact to tabular layout for better readability, then explore advanced techniques like custom padding, selective totals, and dynamic column sizing. You'll also learn how to - - Clean up clutter by removing unnecessary subtotals and toggle icons- Embed high-impact text insights (like "best-selling product") directly into cells- Add KPI icons to highlight key metrics at a glance- Use conditional formatting with data bars for instant visual analysis- Create pseudo-columns to separate numbers and visual indicators cleanlyBeyond just looking better, these changes make your data more understandable and actionable for stakeholders.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://www.goodly.co.in/easy-tweaks-to-instantly-upgrade-your-power-bi-tables===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
The 2 Rules You MUST Follow for One-to-Many Relationships ⚡ Goodly 2025-07-21 | Struggling to create a one-to-many relationship in Power BI? There are two critical rules you must follow—if you break them, your relationships won’t work. First, the column you use for linking cannot contain blank values. Second, the column in your lookup table (the "one" side) must have unique values with no duplicates.In this video, we show exactly what happens when you violate these rules—Power BI throws an error and refuses to create the relationship. We demonstrate how to fix these issues by cleaning your data, removing blanks, and ensuring unique keys.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
How to Switch Rows to Columns in Excel Fast Goodly 2025-07-19 | Need to reorganize your data from rows to columns (or vice versa) in Excel? The TRANSPOSE function makes it effortless. Instead of copying and pasting values manually, this formula automatically flips your data layout with just one step.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
DAX Strict Equals - The Comparison Operator You Didnt Know About Goodly 2025-07-17 | Understanding the difference between standard and strict equals in DAX is crucial for accurate Power BI measures. Many users don't realize that in Power BI, a blank and zero evaluate as equal with a single equal sign (=), which can lead to unexpected results in your calculations. The strict equals operator (==) provides precise comparisons that distinguish between blanks and zeros, giving you more control over your measure logic.In this video, I demonstrate how using double equals signs (==) changes the comparison behavior in DAX. When you need to verify whether a value is exactly zero versus truly blank, this strict comparison operator becomes essential. We show a practical example where checking 0 == BLANK() returns false, while 0 = BLANK() returns true.This technique is particularly valuable when creating conditional measures, data validation checks, or any scenario where you need exact comparisons. The strict equals operator helps prevent subtle bugs in your Power BI reports that might otherwise go unnoticed.Have you encountered situations where your DAX measures weren't evaluating as expected? This strict comparison approach might explain why. Try implementing this in your reports and see if it resolves any of your measure issues.For more essential DAX tips and Power BI techniques, subscribe to our channel. We regularly share practical Power BI insights that can improve your reporting. Let us know in the comments what other DAX operators or functions you'd like us to cover in future videos.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Cut Your Power Query Steps in Half (With These Tricks ⚡) Goodly 2025-07-16 | Grab my Power Query Book - https://products.goodly.co.in/power-query-book/youtu.be/qlbU3jUsQAs?si=_f4l0StOTD61fOqWIf your Power BI queries look like a tangled mess of steps that slow down your reports, you’re not alone. Most people don’t realize how much unnecessary bloat is hiding in their Power Query scripts until they see how clean and fast it could be. In this video, I'm breaking down the exact strategies that turn long, sluggish queries into lean, efficient machines.You’ll learn why those automatic "Change Type" steps are secretly killing your performance, how to batch repetitive actions into single steps, and the smart way to use lists so your queries adapt dynamically instead of breaking when data changes. Plus, I’ll show you how to trim down a 20-step query into just 4 without losing functionality, just raw speed.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://www.goodly.co.in/cut-your-power-query-steps-in-half===== CHAPTERS =====00:00 Intro00:28 Draw the Final Output01:36 The Uninvited #"Change Type" Step04:32 Explore the Menu07:31 Batching & Removing Unnecessary Steps09:19 Modifying the Formula Bar Code12:10 Dynamic Queries Using Lists17:49 Labeling and Parameterizing===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
❌ STOP ❌ Ruining Your Power BI Reports Goodly 2025-07-14 | Tired of your Power BI reports getting messed up because someone moved a slicer? There’s a simple setting that fixes this forever. Head to the View tab and click Lock Objects. Once you turn this on, everything stays exactly where you placed it, but users can still filter and interact with the data.It’s one of those small Power BI features that makes a huge difference, especially if you share reports with others. No more rebuilding layouts or fixing accidental drags. Give it a try and let me know if it helps your workflow.Want more quick Power BI tips like this? Subscribe for daily shortcuts that save you time.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Never Knew Bookmarks Could Do This in Power BI Goodly 2025-07-12 | Want to make your Power BI reports more interactive? Here’s how to let users show or hide slicers with just a button click. All you need are two buttons and two bookmarks—one capturing the state where slicers are visible and another where they’re hidden. Link the buttons to the bookmarks, and you’ve got a slick way to toggle slicers on and off without any hassle.This is a game-changer for reports where screen space is tight or you want to guide users through a specific analysis. No more crowded dashboards or confusing layouts. Just clean, dynamic control over what filters are visible at any time.Give it a try and tell me in the comments—what other Power BI tricks should I cover next? Don’t forget to subscribe for more tips like this!===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Slow Power BI? Use This Slicer Trick! ⚡ Goodly 2025-07-10 | Power BI running slow? Try the Apply All Slicers button from the Optimize tab to boost report performance. In this video, learn how to speed up your Power BI dashboard by applying slicers only when needed. Stop your visuals from updating with every click. Improve Power BI performance, reduce refresh lag, and control filter interactions easily using this built-in trick. Works great for large Power BI reports with multiple slicers. Perfect Power BI tip for faster filtering and better user experience.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Geert v/s Chandeep | Who will win? Power Query Tricks Battle 4 ⚔ Goodly 2025-07-09 | Power Query Book - https://products.goodly.co.in/power-query-book/Hey everyone! I'm excited to have Geert Delmulle joining me for this Power Query Battle. He's not just a Power Query expert - he's the brilliant technical editor behind my book. Seriously, this guy knows Power Query inside and out!In this friendly competition, we're sharing our best Power Query tips and tricks, including:- Dynamic table buffering for lightning-fast lookups- Bulletproof error handling with "?" operators- Some seriously clever custom sorting hacks- And much more!The best part? YOU get to decide who wins! Vote for your favourite tricks in the comments below.And make sure to follow Geert - linkedin.com/in/geert-delmulle-2394a4===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://www.goodly.co.in/power-query-tricks-battle-4/===== CHAPTERS =====00:00 Intro01:42 Geert 109:25 Chandeep 112:36 Geert 217:00 Chandeep 219:58 Geert 324:51 Chandeep 326:50 Geert 431:21 Chandeep 437:19 Geert 543:55 Chandeep 547:10 Geert 653:50 Chandeep 657:27 Geert 71:08:24 Chandeep 7===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Power BI Slicer That Controls Your Visuals! 🤯 Goodly 2025-07-08 | Power BI fields parameter, dynamic slicer in Power BI, switch visuals using slicer, how to use fields parameter in Power BI, create slicer to toggle between columns, region vs channel slicer, fields parameter example, Power BI slicer between dimensions, dynamic visual switch, modeling tab fields parameter, new parameter Power BI, create fields parameter step by step, add region and channel to slicer, Power BI dynamic chart update, how to create selection slicer, Power BI interactive visuals, toggle between Region and Channel using slicer, slicer not linked fix, fields parameter tutorial, Power BI modeling tab new parameter===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
How to Manually Enter Data in Power Query Goodly 2025-07-05 | Learn how to manually enter data directly in Power Query without connecting to an external Excel or CSV file. ===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
How to Identify Good, Bad, and Empty Data Goodly 2025-07-03 | In this video, I will explain Power Query's Column Quality feature that helps you easily analyse the quality of your data columns. ===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Use Measures as Columns in Power BI? YES, It’s Possible! 😲 Goodly 2025-07-02 | What if you want to create a highly customized table visualization in Power BI, one that shows product sales across April, May, and June… followed by the quarter total, then the past 3 months, then last year's quarter, and finally the growth over last year?You can build something like this easily in Excel, but how do you do it in Power BI?In this video, I’ll show you how to use calculation groups to build such a visual. You’ll learn how to:- Use measures as columns- Show the past 3 month's data- Pull last year’s quarter total- Calculate % growth over last year- Build a fields parameter to make your visuals dynamic- Apply dynamic formatting using SELECTEDMEASURE() and FORMAT_STRINGThis is a custom table layout that goes way beyond what Power BI normally allows. By the end, your matrix visual will be fully dynamic, clean, and insanely powerful.youtu.be/2y2VP6i8S8c?si=3hGRXcCehPRSalLW===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://goodly.co.in/use-measures-columns-power-bi/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Before You Clean Data, Use This Power Query Trick Goodly 2025-06-30 | In this quick Power Query tip, learn how to use the Column Profiling feature to get deep insights into any column.With column profile turned on (from the View tab), you can instantly see:- Total and distinct values- Error values and empty values- A value distribution chart with frequencyAnd more—all inside Power QueryBy default, this works on the first 1,000 rows, but you can enable profiling on the entire dataset too (just note it may slow things down on large files).This is one of the fastest ways to clean and understand your data before transforming it!===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Power Query Trick to Instantly Check Data Quality 🧐 Goodly 2025-06-28 | In this short Power Query tutorial, we’ll explore the Column Quality feature under the View tab.With just a simple check, Power Query shows you:✅ How many good values your column has❌ How many error values are present⚪ And how many blank values existThis is an easy way to get data quality insights before starting your transformations.If you're using Power Query in Excel or Power BI, the column quality check can save you time and help you avoid errors later in your analysis.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
See How Power Query Tables Are Connected Goodly 2025-06-26 | Learn how to check query dependencies in Power Query! This quick tutorial shows you how to use the Query Dependencies view to see how your tables are connected helping you manage and troubleshoot your data workflow efficiently.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Build an Invoice and Payment Tracking Dashboard in Power BI Goodly 2025-06-25 | Struggling with complex Power BI problems? Book a consulting call today - goodlyinsights.comDo you face challenges matching bulk payments from customers to individual invoices in your business? In this business case study, I will explain how you can create an advanced yet easy-to-use Invoice and Payments Dashboard. I will also explain how to automatically match bulk payments against invoices using the FIFO (First-In, First-Out) method, eliminating manual Excel adjustments.By the end of this video, you'll be able to clearly see:- Which invoices have been fully paid, partially paid, or remain unpaid.- Real-time balances and customer payment statuses.- How to implement dynamic date filters ("As-on-date" logic).- Best practices in data modeling and DAX calculations.- Simple yet professional dashboard design techniques to clearly visualize financial insights.This solution is ideal for small to medium-sized businesses looking to streamline invoice management, improve cash flow visibility, and efficiently handle bulk payments.If your business needs help building custom dashboards or solving complex data problems, reach out to our team via this form - https://www.goodly.co.in/consulting/===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/Download the File ⬇️ - https://goodly.co.in/build-an-invoice-and-payment-tracking-dashboard-in-power-bi===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Most People Ignore This Power Query Feature 😮 Goodly 2025-06-23 | In this video, I explain what Column Distribution means in Power Query and how it can help you quickly understand your data. You’ll learn the difference between distinct and unique values and how this feature gives you a quick overview of column-level stats.===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Don’t 😲 Manually Copy PDF Data – Use This Power BI Trick Goodly 2025-06-21 | Want to combine data from multiple PDF files in Power BI? In this video, I’ll show you a super simple way to load and merge multiple PDFs—even if each file has multiple pages. You’ll learn how to use the folder connector, pick a sample file, and get clean combined data inside Power BI in just a few clicks.If you're dealing with multiple PDF reports every month, this trick will save you hours! Combine Data From Multiple PDFs in Power BI===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Combine Multiple Excel Files in Power BI (The Smart Way!) Goodly 2025-06-19 | Want to combine multiple Excel files in Power BI without doing it manually? In this video, you’ll learn how to import and merge data from a folder in Power BI when all Excel files have the same structure. We’ll cover step-by-step how to use the “Get Data from Folder” option, select the correct sheet, and let Power BI automatically combine your files. This method is perfect if you’re working with monthly sales reports, yearly financial data, or any repeating Excel templates. No copy-paste needed. Just connect, combine, and analyse!===== ONLINE COURSES =====✔️ Master 'M' in Power Query -https://goodly.co.in/learn-m-powerquery/✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔️ Master Excel Step-by-Step-https://goodly.co.in/learn-excel/✔️ Business Intelligence Dashboards-https://goodly.co.in/learn-excel-dashboards/===== LINKS 🔗 =====Blog 📰 - https://www.goodly.co.in/blog/Corporate Training 👨🏫 - https://www.goodly.co.in/training/Need my help on a Project 💻- https://www.goodly.co.in/consulting/===== CONTACT 🌐 =====Twitter - twitter.com/chandeep2786LinkedIn - linkedin.com/in/chandeepchhabraEmail - goodly.wordpress@gmail.com===== WHO AM I? =====A lot of people think that my name is Goodly, it's NOT ;)My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
