# Combining LODs, table calculations and date logic

*Tableau Consultant Study Guide · Design and Troubleshoot Calculations and Workbooks · Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/combining-lods-table-calculations-and-date-logic*

Layer row-level logic, LOD expressions and table calculations in the combinations Tableau allows, feed FIXED results into row-level date math and distinct counts, anchor date logic to the data's own earliest or latest date, and predict how filters and Specific Dimensions shape the combined result.

- Certification: Salesforce Tableau Consultant
- Exam section: Design and Troubleshoot Calculations and Workbooks
- Study guide: https://www.certifyforce.com/study-guide/tableau-consultant

**Official exam objective:**

> Implement combinations of advanced calculations.

## What the exam expects

- Choose which calculation type (row-level, aggregate, LOD or table calculation) each layer of a combined requirement needs, and which layerings Tableau permits.
- Use a FIXED result inside row-level logic, such as a date difference from an entity's first date or a condition counted with COUNTD.
- Anchor date comparisons to the data's own earliest or latest date instead of the calendar.
- Predict how dimension, context and table-calculation filters affect a calculation that combines FIXED and a table calculation.
- Combine a fiscal calendar with a table calculation's Specific Dimensions so the result restarts at the right boundary.

Key terms:
- **Row-level calculation:** computed for every row of the data source.
- **Aggregate calculation:** computed at the view's level of detail, so it changes as the view changes.
- **Table calculation:** a transformation of the values already in the visualization.
- **Addressing and partitioning:** the dimensions a table calculation moves along and the ones it restarts on.

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Table calculation level | Visualization level of detail only | [Types of Calculations in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_understand_types.htm) |
| Table calc in an LOD | Not permitted in the aggregate expression | [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm) |
| LOD in an LOD | Allowed; the aggregate expression can contain other LODs | [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm) |
| Mixed arguments | Row value with an aggregate raises an error | [How Level of Detail Expressions Work in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm) |
| COUNTD | Distinct items; nulls not counted | [Aggregate Functions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_aggregate_create.htm) |
| FIXED vs dimension filters | Computed before them unless the filter is in context | [How Level of Detail Expressions Work in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm) |
| Table calculation filters | Hide marks; underlying data still used | [How Level of Detail Expressions Work in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm) |
| Specific Dimensions | Checked fields address; unchecked fields partition | [Transform Values with Table Calculations](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm) |

## Check yourself

- Why does a table-calculation filter hide marks without changing the numbers other calculations use?
- What does COUNTD do with null values in its argument?
- Which shelves and cards decide the virtual table a table calculation works on?
- Why does `[Sales] – AVG([Sales])` fail to save while `[Sales] - {AVG([Sales])}` works?

## Sources

- [Types of Calculations in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_understand_types.htm)
- [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm)
- [How Level of Detail Expressions Work in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm)
- [Transform Values with Table Calculations](https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm)
- [FIXED Level of Detail Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_fixed.htm)
- [Aggregate Functions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_aggregate_create.htm)
- [Table-Scoped Level of Detail Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_tablescoped.htm)
- [Fiscal Dates](https://help.tableau.com/current/pro/desktop/en-us/dates_fiscal.htm)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 6 linked practice questions, and unlimited timed mock exams are included with the Tableau Consultant pack (USD $19): https://www.certifyforce.com/practice-exams