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 […]

A common issue with database sources is the presence of NULL values in column. When this data is imported into PowerBI it can often skew the report and […]

Conditional logic is a core aspect of any report, most often we see something similar to formatting the output based on some condition or value. However we can […]

As its name suggests it is used to change the format of a particular value. Often used with dates it’s a great way to change the look of […]

Often in PowerBI we have to deal with strings in such cases the FIND function comes handy in fetching the position of a particular word within a string. […]