What DAX functions have you used in previous projects?
For this SQL exercise, treat prior project usage as records in the provided tables. Return functions used by at least two distinct projects during 2024.
function_name, function_category, projects_using, usage_records, and latest_used_dateprojects_using descending, then function_name ascending| Column | Type | Description |
|---|---|---|
| function_namePK | VARCHAR(100) | Name of the DAX function |
| function_category | VARCHAR(100) | Functional category of the DAX function |
| Column | Type | Description |
|---|---|---|
| usage_idPK | INT | Unique usage record identifier |
| project_id | INT | Identifier of the project where the function was used |
| function_name | VARCHAR(100) | DAX function used in the project |
| first_used_date | DATE | Date when the function was first recorded in the project |
| last_used_date | DATE | Most recent recorded use date |
| usage_count | INT | Number of measured uses in the project record |