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.