| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "DAX Calculations"
(Created page with "The DAX tab within the Measure Calculations wizard can be used to create quick predefined DAX calculations. center|500px To create custom DAX calculat...") |
|||
| Line 1: | Line 1: | ||
The DAX tab within the Measure Calculations wizard can be used to create quick predefined DAX calculations. | The DAX tab within the Measure Calculations wizard can be used to create quick predefined DAX calculations. | ||
| − | + | To create custom DAX calculations, use the [[Tabular#Calculations|Custom Calculations]] wizard. This wizard is also used for managing, editing and deleting calculations. | |
| − | |||
| − | To create custom DAX calculations, use the [[Tabular#Calculations|Custom Calculations]] wizard. | ||
== Calculation Types == | == Calculation Types == | ||
| Line 10: | Line 8: | ||
===Aggregate by Category=== | ===Aggregate by Category=== | ||
| + | You will need to select a column which is the 'category' | ||
| + | For example, selecting 'City' in a Max per Category calculation would return the highest measure value for all cities (apply all filters in the grid). | ||
| + | |||
| + | For a weighted average calculation, you also need to select the value which will act as the weight. This can be a measure or an aggregate of a column. | ||
*Average per category | *Average per category | ||
*Variance per category | *Variance per category | ||
| Line 19: | Line 21: | ||
===Filters=== | ===Filters=== | ||
| + | These calculations require a member from a column and calculates the measure value for that particular row. | ||
*Filtered value | *Filtered value | ||
*Difference from filtered value | *Difference from filtered value | ||
*Percentage difference from filtered value | *Percentage difference from filtered value | ||
| + | |||
===Time Intelligence=== | ===Time Intelligence=== | ||
| + | For time related calculations a date column must be selected. Year-over-year etc. calculations also require a number which represents the number of years (or months etc.) over which to calculate the change. | ||
*Year to date total | *Year to date total | ||
*Quarter to date total | *Quarter to date total | ||
| Line 36: | Line 41: | ||
===Mathematical Operations=== | ===Mathematical Operations=== | ||
| + | These calculations require a value to operate with - this can be a measure or an aggregate of a column. | ||
*Addition | *Addition | ||
*Subtraction | *Subtraction | ||
Revision as of 14:26, 11 September 2018
The DAX tab within the Measure Calculations wizard can be used to create quick predefined DAX calculations.
To create custom DAX calculations, use the Custom Calculations wizard. This wizard is also used for managing, editing and deleting calculations.
Contents
[hide]Calculation Types
The following calculations are available.
Aggregate by Category
You will need to select a column which is the 'category' For example, selecting 'City' in a Max per Category calculation would return the highest measure value for all cities (apply all filters in the grid).
For a weighted average calculation, you also need to select the value which will act as the weight. This can be a measure or an aggregate of a column.
- Average per category
- Variance per category
- Max per category
- Min per category
- Weighted average per category
Filters
These calculations require a member from a column and calculates the measure value for that particular row.
- Filtered value
- Difference from filtered value
- Percentage difference from filtered value
Time Intelligence
For time related calculations a date column must be selected. Year-over-year etc. calculations also require a number which represents the number of years (or months etc.) over which to calculate the change.
- Year to date total
- Quarter to date total
- Month to date total
- Year-over-year change
- Quarter-over-quarter change
- Month-over-month change
Totals
- Total for subcategory (filters applied)
- Total for subcategory (filters not applied)
Mathematical Operations
These calculations require a value to operate with - this can be a measure or an aggregate of a column.
- Addition
- Subtraction
- Multiplication
- Division
- Percentage difference
