Smantin Data

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 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 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