Prompt Details
Model
(claude-4-6-sonnet)
Token size
347
Example input
[TABLE NAME]: HR
[RELATED TABLE]: Departments
[PRIMARY OWNER]: Line_Manager
[FALLBACK OWNER]: HR_Business_Partner
Example output
Order Owner =
VAR vPrimary = RELATED('Customers'[Account_Manager]) -- Level 1: look up account manager from related table
VAR vFallback = RELATED('Customers'[Region_Lead]) -- Level 2: fall back to region lead if account manager is blank
RETURN
SWITCH(TRUE(),
NOT ISBLANK(vPrimary), vPrimary, -- return account manager when present
NOT ISBLANK(vFallback), vFallback, -- fall back to region lead
"Unassigned" -- final catch-all when both lookups are blank
)
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
CLAUDE-4-6-SONNET
Generates a production-ready DAX calculated column that assigns an owner to each row using RELATED to look up a related table, with a multi-step COALESCE fallback chain to handle missing or blank values at every level. Works for order ownership, HR line management, project accountability, financial account assignment, or any Power BI model where rows need a responsible owner derived from related data. Handles blank lookups, null values, and reserved DAX keyword conflicts automatically.
...more
Added 1 week ago
