Learn how to use Power BI in your organization from our useful Microsoft Power BI tutorials.
When working with Power BI for my client, I need to filter rows based on the value in another column and create a separate table. To do this, we need to use the Filter() function, then, based on a condition, create a table. In this post, I will share how I filter data in Power BI using … read more…
While working on one of my Power BI reports, I realized my dataset wasn’t in the format I needed. After applying filters and validation rules, I wanted to add a column with a fixed value for each row. So, I started researching and found that Power BI offers multiple ways to add a fixed-value column, … read more…
In my organization, when I am creating a Power BI dashboard, and many times I need to add new columns based on different conditions. Sometimes I must check multiple rules, use AND/OR, or handle errors in the data. I also need to add a column only if it doesn’t already exist. Power Query makes all … read more…
When working with Power BI, I need to check if a column contains a specific word or value and then create a new column based on that. At first, I struggled with this because there are many different “contains” scenarios in Power Query. After working on e-commerce dashboard projects, I learned some easy, reliable ways … read more…
In my organization, I am creating a Power BI dashboard, and I often encounter columns with blank or null values. These empty fields can cause issues in calculations and visuals. To fix this, I started using Power Query and DAX to check for blank or null values and create clean, meaningful columns. In this tutorial, … read more…
Recently, while setting up a reporting dashboard for an organization, I had to work with some data that wasn’t fully clean. One of the tables had repeated values, and before using it in visuals, I needed to clean and prepare it properly. To do that, I first created a duplicate column so I could apply … read more…
Recently, while creating an HR dashboard in Power BI, I encountered a situation in which one table had an important column I also needed to use in another table. Instead of manually copying data, I explored different ways to bring that column into the second table. In this tutorial, I will show you how to … read more…
A few days ago, I was working on a dashboard for one of my clients. The dashboard compared sales data from two different sources: Initially, the sales IDs and timestamps didn’t match. After some research, I realised the issue wasn’t the sales IDs at all, it was the time zone difference. Excel was showing data … read more…
Microsoft Power Platform is a bundle of low-code tools that helps businesses build custom apps, automate workflows, and analyze data—all without advanced coding. The suite includes Power Apps for app creation, Power Automate for workflow automation, Power BI for data analysis, and Power Pages for website building. With Power Platform, organizations can tackle business problems … read more…
Data Analysis Expressions (DAX) is the formula language that you can use to do calculations in Microsoft Power BI. It helps transform raw data into meaningful insights through a collection of functions, operators, and constants. DAX contains over 250 functions designed specifically for business intelligence, allowing users to create complex calculations that would be difficult … read more…
I believe Power BI is now an essential tool for businesses that want to take advantage of data analytics. More and more companies are relying on insights from data to make decisions. This has caused the demand for people with Power BI skills to keep increasing. Having Power BI expertise has become valuable in the … read more…
In this Power BI tutorial, we’ll learn how to compare two columns from different tables. We’ll examine the data in each column and find any similarities or differences between them. We will also learn how to compare two columns in Power BI, and Dax will compare two columns in different tables in Power BI. Additionally, … read more…
Power BI Date Hierarchy organizes dates into different levels of granularity, such as year, quarter, month, and day. In this tutorial, we will learn how to create date hierarchy in Power BI and how to work with Power BI add week to date hierarchy. Also, we will cover the topics below: Power BI Date Hierarchy … read more…
A Power BI Date Slicer is like a magic wand for your data. It lets you easily filter and visualize your data based on dates. Think of it as a virtual tool that helps you slice and dice your data by time periods such as days, weeks, months, or even years. In this tutorial, we … read more…
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Learn how to build a SharePoint Permission Checker Agent using Copilot Studio. Using this agent, you can check library-level and file-level permissions. Also, identify Users, SharePoint Groups, and Permission Levels.
📅 1st July 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App