Your question is DAX Functions Used. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |