Instead of coming from a data source, this kind of model table is defined by a DAX formula. It's always held in Import mode and recomputed on each refresh, which makes it handy for staging intermediate results or duplicating a table for role-playing.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Calculated table in context, with comparison tables and the common traps.
Terms in this definition
- Search data source
Connection object in Azure AI Search pointing an indexer at its content, which must be a supported source: Blob, ADLS Gen2, Table Storage, Cosmos DB, Azure SQL, SQL Managed Instance or SQL Server on Azure VMs. One indexer, one data source.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- Import mode
Copies data into the model's in-memory cache, so a refresh is needed before changes appear. It is Power BI's most used storage mode and what a new Power BI Desktop solution starts with.
- staging
Pre-loading image components onto hosts with vSphere Lifecycle Manager, without applying them yet, so that hosts spend less time in maintenance mode when remediation runs.
Related terms
- CALENDAR
Generates a date table as a calculated table: given a start and end date, this DAX function returns a single column, called Date, listing every day in between, including both ends.
- Field parameter
Puts a slicer in front of report readers so they can swap which measures or dimensions appear in a chart. Under the hood, Power BI stores it as a calculated table.