Learn how to use Power BI in your organization from our useful Microsoft Power BI tutorials.
Last week, I worked on a Power BI customer support report that required showing the number of support tickets created in the last 30 days. Also, it filters the data to show the tickets created in the previous seven days. All these things are possible by using the Power BI DAX statement. In this Power … read more…
Recently, I was working on a Power BI report and needed to filter data for the current year. This is a common requirement for many reports, as it helps in analyzing and visualizing data to the ongoing time period. To achieve this, we can use DAX (Data Analysis Expressions) in Power BI to dynamically filter … read more…
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…
While working together, one of my Power BI clients wanted to filter the data between two dates or based on the date selection. I’ve found that using the Power BI DAX function is extremely easy. In this Power BI tutorial, I will explain how to filter date using Power BI DAX, Power BI DAX filter … 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…