Data Analysis Tutorials
Will 
In this article, we will show you how can calculate the difference between two dates in Power BI using DAX. The DAX function we use to achieve this is DATEDIFF. This returns the difference between two date fields and can be expressed in days, weeks, months, seconds, and more. We go over different common questions … Read more
In this article, we will show you how to sort multiple columns in your Power BI tables. You can sort a column in any table by clicking the column header. This will sort the column in ascending order. If you click the column header again, it will sort the column in descending order. When you … Read more
In this article we will give you an easy solution on how to remove blank values from your slicer in Power BI. Problem: Blank value in Power BI slicer The issue you’re experiencing is a blank value or the word ‘blank’ in your slicer. It usually appears as the top option of the slicer and … Read more
In this article, we will show you two methods of how to sum multiple columns in Power BI. The first method uses a calculated column and the second method uses DAX functions. We will also cover common questions such as incorporating filters or combining columns from different tables in Power BI. How to sum multiple … Read more
When customizing the look of your Power BI reports, you may have wondered if you can change the background color of your visuals. This is especially important when you have changed your canvas color and want to make the backgrounds of your visuals transparent. In this article we will show you how to change the … Read more
In this tutorial, we show you how to round time and datetime values to the nearest 1, 15, 30 and 60 minutes in Power Query and Power BI. Rounding time in Power Query To round times or datetimes in Power Query, one simple formula is used. This can either be in a custom column, or … Read more
In this tutorial, we show you two easy methods for calculating ages from dates of birth in Power BI: Calculating age from date of birth using Power Query Firstly we will show you how to calculate age from date of birth in Power Query. Here are some example dates of birth: If you want to … Read more
We will show you how to check to see if a value exists in another column in Power Query. If you want to check if a value exists in another column in the same table, there are two methods we have to share. If you want to find values in columns in two different tables, … Read more
We will show you how to find and replace values greater or less than specified values in Power Query. You can do this easily using either the Table.ReplaceValue function or Table.TransformColumns function and combine one of these with an if statement and the <>= operators. Here is an example of a table with numbers between … Read more
This article will show you how to find and replace values based on another column in Power Query. Here is an example table with references in the first column and types of animals in the second column. To demonstrate how to find and replace values based on other columns, we will use the ‘Reference’ table … Read more