Create Relationships: Define relationships between different tables to create a cohesive data model. Use DAX Functions: Use Data Analysis Expressions (DAX) to perform calculations and create measures.

After creating the relationship, Excel will identify those tables as a Data Model Table, not a Worksheet Table in the dropdowns. To see what Excel did, click Manage Data Model in the Data Tools group.