XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

DAX Calculations

Revision as of 13:40, 11 September 2018 by CFrance (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The DAX tab within the Measure Calculations wizard can be used to create quick predefined DAX calculations.

DaxCalcs1.PNG

To create custom DAX calculations, use the Custom Calculations wizard.

Calculation Types

The following calculations are available.

Aggregate by Category

  • Average per category
  • Variance per category
  • Max per category
  • Min per category
  • Weighted average per category
DaxCalcs Category1.PNG

Filters

  • Filtered value
  • Difference from filtered value
  • Percentage difference from filtered value

Time Intelligence

  • 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

  • Addition
  • Subtraction
  • Multiplication
  • Division
  • Percentage difference
Retrieved from ‘https://help.xlcubed.com/index.php?title=DAX_Calculations&oldid=8860’