Learn how to use Power BI in your organization from our useful Microsoft Power BI tutorials.
Last week, while working on a Power BI dashboard, I needed to calculate the difference between two dates using DAX. I researched this and found that the Power BI DATEDIFF() function is the best option for this purpose. In this Power BI article, I will explain the Power BI DATEDIFF() function and its syntax. We … read more…
When working with Power BI, you might encounter issues with date filters that do not work as expected. There can be various reasons for this, such as incorrect DAX formulas, wrong date formats, an improperly set date table, or missing relationships between the date table and data table. Below, I will present some common problems … read more…
Sometimes, you may need to display unique dates from a dataset in a Power BI report. You can create a calculated table or column that filters out duplicate dates to do this. Let’s look at an example of how to filter distinct date using Power BI DAX. Filter Distinct Date Using Power BI DAX While … read more…
Sometimes, you may receive a requirement to create a new table from an existing table in Power BI. This task can be for various reasons, such as organizing data more effectively or preparing it for specific analyses and visualizations. So, I thought to show you how to create a table from an existing table in … read more…
While working on Power BI, I was required to create a report using sales data from January to December, with each table having the same columns. To create the report, we needed to combine this data, and I learned that we can use the Append Columns method in Power Query Editor. I thought I would … read more…
This Power BI tutorial will teach us to sum and display values using the group by function and how to sum values with the Power Query group by function. Additionally, we will discuss the topics below: Power BI Sum Group By Column Imagine you’re an analyst for an online retail store. You want to understand … read more…
A Power BI slicer lets you filter data easily. You can use multiple columns to slice and dice your data for clearer insights. In this tutorial, we will learn how to create a slicer with multiple columns in Power BI and a Power BI slicer with a vertical list of multiple columns. Additionally, we will … read more…
In Power BI, merging columns means combining information from different columns into one. We use the Power BI Concatenate Function to merge columns in Power BI. This tutorial will teach us about Power BI Concatenate Function and how to merge columns in Power BI using DAX. Additionally, we will discuss the topics below: Power BI … read more…
Calculated columns are a powerful feature in Power BI that allows you to extend your data model by creating new columns based on existing data using DAX formulas. In this tutorial, we will learn what a calculated column is in Power BI and how to create a calculated column in Power BI. Additionally, we will … read more…
In this article, we will learn about the Power BI matrix multiple columns and the Power BI matrix multiple column headers. Additionally, we will cover some topics listed below: Power BI Matrix with Multiple Columns Here, we learn how to display the matrix visual with Multiple columns in Power BI. Scenario: Imagine you’re the HR … read more…
Power BI is a great tool for data analysis. When people first learn DAX, they use it for basic calculations like addition and subtraction. In this tutorial, we’ll learn how to subtract using the subtract function and how to add two measures together in Power BI. In addition to that, we’ll explore several other examples … read more…
In this Power BI tutorial, we will learn how to convert month numbers to month names in Power BI. We will also see how to get the month name from the date and how to convert the month number to the month name in the Power Query editor. Convert Month Number to Month Name in … read more…
Embedding a Power BI report in SharePoint Online means putting it directly into a SharePoint page. This allows any member of your organization to access the Power BI report on the SharePoint site. In this tutorial, we will learn how to embed Power BI reports in SharePoint online and add them to the SharePoint site. … read more…
In this Power BI DAX Tutorial, we’ll explore the difference between USERNAME() and USERPRINCIPALNAME() in Power BI DAX functions. We’ll also cover the syntax of these functions, how to use them in Power BI, and what they return in both Power BI Desktop and the Power BI service. What is a username in Power BI? … read more…
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App
Download 135+ Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…