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

In this post we talk about the DAX Formula called Filter. Filter as its name suggests is used to filter the data in a table based on some […]

Except much like its SQL equivalent is meant to be used when you want to exclude certain rows from within the result set. Basically everything from Left table […]

A very common requirement especially for reports that rely on age etc. We use DateDiff function to calculate the difference in intervals between two dates. This provides an […]