Search for a command to run...
Series
Educational and Technical Articles on Business Intelligence.
What is DAX? DAX is an expression language for distilling your data into bite-sized insights. Where is DAX used? Power BI, Power Pivot, SSAS Tabular Mode, and Azure Analysis Services. What is DAX Good at? Aggregations: Dax is used for turning milli...
A relational row-based database is like a Swiss Army Knife. It is pretty good at a lot of different things, but sometimes, you have a narrowly-defined purpose. Sometimes you need a scalpel instead of a Swiss Army Knife. A columnar database is like th...
What is Encoding We have talked about why analytics favors a column-based approach and how Vertipaq works with columns. We are going to dive a little bit deeper. We are going to show how using a columnar data store allows for really impressive compre...
Adding Meaning to a Data Model There are two different ways of adding meaning to your data model. Calculated Columns A way to add columns to your tables based on a formula or expression. Measures A way of creating your own aggregations of the dat...
Calculated Columns Let's talk about some of the unique characteristics of a calculated column. First is the fact that they're calculated. So, we need to create a formula or expression to determine their value. That calculation is computed at time of ...
One of the most powerful features of DAX is the ability to manipulate filters. This allows for complicated time based logic, such as previous year to date. It allows for various comparisons, like a percentage of total sales. Visuals and Pivot Tables ...