Articles in this series
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...
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...
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...
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...
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...
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...
