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 […]
PowerBI DAX – CONVERT
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 […]
PowerBI DAX – CONTAINS
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 […]
PowerBI DAX – CONCATENATE
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 […]
PowerBI DAX – CALENDAR
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 […]
PowerBI DAX – CALCULATETABLE
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 […]
PowerBI DAX – CALCULATE
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 […]
PowerBI DAX – ALL
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 […]
MS SQL Machine Learning -Add Modules -Part 2
In this second post we explore how to setup MSSQL Server Machine Learning. Now that we have Machine learning services installed on SQL Server the next thing will […]
MS SQL Machine Learning -Install ML -Part 1
In this series of post we are going to cover all the steps required to be able to perform Machine learning on Microsoft SQL Server. We will start […]