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

When working with database system converting data between different data types is one of the tasks ETL developers find themselves doing very often. It is highly recommended to […]

Contains Function is similar to the Filter except for the fact that is scalar in nature. What this means is we use Contains when looking for a specific […]

A common expression most database developers are familiar with CONCATENATE. It combines text data from multiple columns and represents it as a single string. Similar to CALENDAR Concatenate […]