Power BI - DAX

Data Analysis Expressions (DAX). DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models.

You have 3 types
Tables | Columns | Measures

Create a Table - 2 Options
Ribbon -> Modeling -> New Table  OR  Ribbon -> Home -> Enter Data

Create a Column
Modeling -> New column

Create Measure
Home/Modeling -> New measure (create calc yourself) OR quick measure (some pre-established measures that you just need to tell which fields you want to use)

When to Use

Table - Store your measures in a single place;
   - Create a Measure Switch (click for blog link on how to do this)
   - Create Dummy Data
   - Role-playing dimensions
Column - Perform a static calculation on existing data that won’t change based on user interactions.
Measure - Perform a dynamic calculation on aggregated data that will respond to user interactions.

*Most of the time you would be creating measures, as it is better for performance*

Author:
Francisco Rei
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab