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 […]
How to navigate between pages in PowerBI
In this post we explore the way to navigates between pages in PowerBI. The latest release of PowerBI has made this process very simply and most developers will […]
How to use Relative Time Filter in PowerBI
In this post we cover how to use the Relative Time Filter in PowerBI desktop. A great features to have when reporting the relative Time Filter Option allows […]
Power BI Automated page Refresh
Automated page refresh is a feature that allows the developer to display real time information on the power Bi report. This is not to be confused with features […]