This DAX functions reference guide is for anyone who wants a fairly complete guide to the main DAX functions you are going to need to create business intelligence reports for businesses with Power BI. Converting and Checking Data Types with DAX Functions When writing DAX functions, such as with SQL, you will find that you… Read more: DAX Functions Reference

Learning how to optimize DAX measures is an essential skill for improving slow-running reports. We can use DAX Studio to help us understand how our DAX measure is translated into code that can retrieve the data for us, and it gets pretty complex. A summary of the steps for executing a Power BI report measure… Read more: DAX Optimization – Analyzing the Query plan and storage retrieveal

There are different ways we can build multiple DAX measures at once in Power BI. This can save time and can be useful if you have a good understanding of what you require. Creating measures in Power BI Desktop individually is a slow process, but there are alternatives that are good to learn. Creating multiple… Read more: How to create Multiple DAX Measures

Improving DAX measure speed. We can take a measure like the one customer order measure, add it to a card visual, and use the performance analyser to give us the DAX query, which we can paste into the performance analyser. However, we may see different results if we use it in a matrix, so we… Read more: Analyzing DAX Server Timings in DAX Studio

The DISTINCTCOUNT() function can slow down reports, but if it’s required, then what are the alternatives?Here we test DISTINCTCOUNT DAX speed against other DAX Options. Test 1: Adventure Works The measures all give the same results, but which one is faster? We can test these measures by opening the above matrix for all years to… Read more: Testing DISTINCTCOUNT() Speed in DAX

We can test the DAX performance in measures using the performance analyzer in Power BI to see which table function used in a formula performed best. Below are the results of 10 tests per measure. SUMMARIZECOLUMNS() and SELECTCOLUMNS() are neck and neck, with the old SUMMARIZE() function finishing last. We will check out the results… Read more: Measuring DAX Performance of DAX Table Functions

The DAX Window function and DAX Offset function make life easier than trying to access a specific slice of a table in a DAX measure. The DAX Window Function To use the Window function, we can start by creating a virtual table of customer sales by sales key using the CALCULATETABLE function and then creating… Read more: How to use the Window and OFFSET Functions in DAX Measures:

To filter DAX measures, the application of various filter arguments is crucial to controlling the output of DAX measures when visual filters are present on a report page. When CALCULATE() is used in an expression, any filters applied will override any existing filters on the filter being applied.e.g. CALCULATE(SUM(V_FactOnlineSales[SalesAmount]), V_DimProduct[BrandName]=”Litware”)Any filter on V_DimProduct[BrandName]is removed and… Read more: How to filter DAX Measures In Power BI

Creating multiple measures in DAX Query Editor It may be useful to create templates for creating DAX models, using commonly used DAX measures. Here we create a template for commonly used sales measures, such as Sales YTD, Sales Last Year, Sales Year on Year, and Sales Year on Year %, we can then apply the… Read more: How to Create Multiple Measures With Power BI DAX Query Editor

Demonstrating the use of the DAX Index function with the Contoso Retail Data warehouse. We can start off by building a virtual table in the DAX query editor, which we can use to apply the Index function. The table created is a list of the first 10 customers by customer key from the DimCustomer table.… Read more: How to use the DAX Index Function in DAX Measures

An Example of Using the DAX RANKX Function To demonstrate the use of the DAX function, we’ll start by creating a simple sales table with the sales amount and the year. Then we’ll add additional columns to create examples of using the RANK function. In the first example (SimpleSalesRank), we’ll just create a simple ranking.… Read more: How to use the RankX Function in DAX Measures

The DAX Running Total Quick Measure An example we start with we a sales and date table to create our running table sales from. We start by creating a sales measure as follows: Sales = SUM(FactSales[SalesAmount]) Next, we create a quick measure to create the Running Total in Sales and add it to our table:… Read more: Understanding the DAX Running Total Quick Measure

If you look around the DAX functions, you are going to be disappointed. There is no DAX week to date function like there is in Tableau. There are different methods you can Google, but let’s create our one here from scratch.In this example, we are using the FactOnlineSales table from the Contoso Retail DW.Before we… Read more: How to calculate Week-to-Date Sales in a DAX Measure