Calculated Tables

In Power BI, calculated tables allow you to create new tables in the data model by defining a table formula. Calculated tables create entirely new tables based on a formula or expression. This can be useful for aggregating or summarizing data in a way that is not easily achieved using the existing tables.

User Interface

  1. Table Name - Name of the calculated table created.

  2. Is Hidden? - It clarifies whether a table is hidden or not.

  3. Expression - Formulas which are written to define the logic to generate values for a new calculated table.

  4. Column - Total count of columns created based on the DAX expression.

  5. Hierarchies - Total number of hierarchies in the table

  6. Measures - Total count of measures present in the calculated table.

  7. Partitions - Total number of partitions

  8. Annotations - Total number of annotations

  9. Descriptions - Comments or notes explaining the purpose, structure, or usage of the calculated table.

  10. Is Featured Table? - Displays if the table is set as featured in the semantic models.

  11. Is Date Table? - (Yes/No) Tells if the table is a date table or not.

Last updated