A lot of times, the business will come back to you and ask—can you create a visual where I can switch between calendar year and fiscal year? In this video, I’ll show you exactly how to build that! We’ll start by setting up a date table that supports both calendar year and fiscal year, then create a slicer to toggle between them. I’ll also walk you through writing the right DAX calculations for YTD sales and show you a neat trick to fix the spillover issue in your visual. Oh, and did you notice that dotted line? We’ll talk about […]

In this video, I’ll show you how to replicate common Excel calculations in Power BI using both visual calculations and DAX. We’ll go through contribution analysis, year-to-date totals, and growth over last year, covering the best approaches and key nuances to watch out for. If you’ve ever wondered how to translate Excel formulas into Power BI, this video will help you get it right.   Replicating Excel Calculations in Power BI

Excel for CEOs (What No One Tells You!) Excel is used by everyone in an organization—from analysts crunching numbers to executives making big decisions. But if you’re a CEO, you don’t need to know every formula or spend hours building reports. Instead, you need to focus on the right Excel skills to get the insights you need, fast. In this blog, I’ll walk you through the essential Excel skills every CEO should master—not just the technical ones, but also the mindset and approach that will make your life easier. 1. How to Ask for the Right Reports One of the […]

In this blog, I’m going to explain 7 of the most important Power Query functions that help you go beyond the user interface and solve advanced data cleaning problems. The video is divided into three parts: Part 1: Enhancing UI Functions: We’ll explore how to tweak built-in functions like table.addcolumns and table.pivot for custom solutions. Part 2: Beyond the UI (Core M Functions): We’ll dive into powerful M functions not found in the UI, including table.group, table.skip, table.twocolumns, table.fromcolumns, and list.transform. Part 3: List Transformations & Automation: We’ll focus on list.transform in detail, showing how to automate data transformations, handle […]

When I started working with Power BI as a beginner, I thought mastering it meant learning all the DAX functions. Turns out, I was wrong! You only need a few powerful functions to handle most of the work. In this blog, I’ll walk you through the Most Valuable Functions (MVFs) in DAX—functions you’ll use repeatedly to solve real-world problems. Whether you’re preparing for Power BI DAX interview questions or just starting with DAX, this tutorial will help you simplify your approach by focusing on key functions and categories. I’ll explain how these functions work and how to apply them with […]