Learn how to use Power BI in your organization from our useful Microsoft Power BI tutorials.
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…
Power BI color based on value is like giving your data a makeover to make it easier to understand. Imagine you have a bunch of numbers representing sales for different products. You can tell Power BI to change the color of those numbers depending on how high or low they are compared to a certain … read more…
In this Power BI Tutorial, we will learn about the Power BI SUM multiple columns and how to sum 2 columns in Power BI. Additionally, we will discuss the topics below: Power BI Sum Multiple Columns Sum multiple columns Power BI functionality allows you to add up the values in several columns of your dataset to create … read more…
Let’s say you need to add a new column to a large Power BI table depending on certain criteria. In this case, the conditional column option in Power BI is really helpful as it significantly simplifies the work. In this Power BI tutorial, I will explain how to add Conditional column in Power BI and … read more…
In this Power BI Tutorial, we will learn about the Power BI Group By function and Power BI Count Group By. Also, we will cover the topics below: Power BI Group By function Power BI GROUP BY is a function used in the query editor or in DAX (Data Analysis Expressions) to combine data based … read more…
Did you know you can divide in Power BI using several different techniques? The fastest is to use the DIVIDE DAX function. In this Power BI Tutorial, we will learn how to divide two columns using Power BI DAX and Power BI measure divide two columns. Additionally, we will discuss the topics below: DAX Divide … read more…
Did you know that you can capture the current state of your report page with the help of Power BI Bookmarks? Yes, that’s right. In this tutorial, we will talk about what is a bookmark in Power BI, what is the use of bookmark in Power BI, and Power BI Bookmark navigator with examples. Additionally, … read more…
One common task in data analysis is working with dates. Power BI Power Query provides functions for working with dates, including getting the current date and other date-related functions. In the tutorial, I will discuss Power Query Today Date in Power BI and Power Query Today Minus 7 days. Also, we will cover the topics … read more…
When working in Power BI, you might encounter a situation where your data has merged columns, such as having too much information in one column, like “PowerBIDesktop.“ In that case, you can use Power BI’s Split Column option to divide that column into multiple columns, like “Power BI Desktop.“ In this tutorial, we will learn … read more…
In this Power BI tutorial, I will explain all about Power BI Power Query examples, Power Query m Language examples, and Power Query Advanced Editor examples. Also, we will cover the topics below: What is Power Query in Power BI? Power Query is a feature within Power BI (also available in Excel) that allows users … read more…
The Power Query Editor in Power BI is a strong tool for transforming data. It helps you clean and manipulate data right within Microsoft Power BI. In this tutorial, I will explain how to create table in power query, including: Power Query Create Table To create a table in power query, follow the steps below: … read more…
When using Power BI, you might encounter a situation where you need to apply an IF condition with dates or Power BI IF Date. What will happen then? In this tutorial, we will see how to work with the Power BI if statement with dates and Power BI if date is between two dates then … read more…
When you think about stacked charts in Power BI, there are two main types: Stacked Bar Chart and Stacked Column Chart. In this Power BI Tutorial, we will discuss What a Stacked bar chart Power BI is and how to create Stacked bar chart in Power BI. Also, we will learn what a Power BI Stacked column chart is and how to create a … read more…
When we discuss Power BI logical functions, we usually start with the IF function. But there is a problem: the IF function becomes more complex if we have multiple conditions. That’s where the Power BI Switch function comes in handy. In this tutorial, we will discuss the Switch function in Power BI and the switch … read more…
