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 […]
PowerBI DAX – SWITCH
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 […]
PowerBI DAX – SUMMARIZE
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 […]
PowerBI DAX – SUM and SUMX
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. […]
PowerBI DAX- SUBSTITUTE
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 […]
PowerBI DAX – SAMEPERIODLASTYEAR
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 […]
PowerBI DAX – ROUND
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 […]
PowerBI DAX – RANKX
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 […]
PowerBI DAX – Percentile.Ex
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 […]
PowerBI DAX – PARALLELPERIOD
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 […]