A common issue faced when working with PowerBI is the limitation of having only one Active relationship between two tables. While this is a not an issues when […]
PowerBI DAX- TREATAS
Once we are able to create virtual tables within PowerBI using Functions such as EVALUATE , CALCULATE TABLE etc it might be required to filter the contents of […]
PowerBI DAX- TOTALYTD
A very useful kind of report is called a cumulative report. Which is based on summarizing data cumulatively. This means we can see the area chart as progressively […]
PowerBI DAX – TOPN
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 […]