Another commonly used function is the TOPN function. It is used for both TOP and BOTTOM use cases. In this example to demonstrate the basics we are first […]

Switch is a DAX function that is used frequently to create custom groups and classifications. In this example we use Switch to create a column called approval where […]

A useful function when measures need to be created on top of summarized data the SUMAMRIZE Function as its name suggests returns a table containing aggregates based on […]

In this post we cover the difference between the DAX Formula SUM and SUMX. If you are even somewhat familiar with EXCEL you already know what SUM does. […]

The DAX Function SUBSTITUTE can be treated like the Replace function in MSSQL Server. It replaces a string with another string. Its syntax is also similar to the […]

In the previous post we saw the shortcomings of using ParallelPeriod DAX function when it comes to summarizing data against a different dimension attribute. This problem can be […]

Often the result of a calculation will have decimal places. However it is may not be required to show the decimal places at the time of visualization. In […]

In our previous post we saw how to identify the top N Sales Persons a common follow up to this task it to rank the Sales Persons as […]

Percentile is a great way to find distribution of data across your range of values. It give a great feel for how the data is distributed and is […]

Often in Business Intelligence developers are required to create Measures based on time series analytics like compare this year sales with last years. In such cases you can […]