Search for a command to run...
Articles tagged with #data-visualisation-1
Evaluation Contexts So now that know how to use iterators, it's time for a little review. You can get away with not having a complete understanding of them and still use them pretty successfully for a while, but often iterators can still be confusing...
Anytime we want to do anything with multiple columns, We're going to use something called an iterator. An iterator basically is like a for loop in a programming language or a cursor in SQL. It processes and expression and it does it row by row. And t...
FILTER Function Sometimes you need to apply more advanced filters. The FILTER function allows you to do that. So you might winder why we need a filter function if we can filter data using CALCULATE. Well it turns out CALCULATE is designed to be fast,...
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 ...
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 ...
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...