🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate31 / 150
Question 31 of 150
You are building a calculated column on the Sales fact table in a Fabric semantic model. Each row in Sales has a ProductKey that links to a Product dimension table via a single active one-to-many relationship (Product → Sales). You need the calculated column to return the CategoryName from the Product table for each sales row, so you can later group sales without physically merging the tables during transformation. Which DAX function should you use in the calculated column?
Reviewed for accuracy · Report an issueNext question