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

In this post we explore the CALENDAR DAX Function. This particular function unlike stuff we used before doesn’t really perform a calculation instead it creates a date table […]

This is a powerful function for advanced measures used correctly it give great flexibility in how you slice and dice the data. It will be much easier to […]

In this post we explore the use of CALCULATE. Calculate is one of the most frequently used DAX Formulas. This is because it is every flexible and can […]

Another commonly used DAX function in PowerBI is the ALL function. It is used to clear filters that may be applied. When visualizing data in PowerBI the data […]