Which DAX formula should you use?

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products.
The Invoice Line Items table has the following columns:
Product Id
Unit Sales Price
The Unit Sales Price column stores the unit price of the product sold.
The Products table has the following columns:
Product Id
Minimum Sales Price
The Minimum Sales Price column is available only in the Products table.
You add a column named Is Undersell to the Invoice Line Items table. The Is Undersell column must store a value of TRUE if the value of the Unit Sales Price is less than the value of the Minimum Sales Price. Otherwise, a value of FALSE must be stored.
You need to define the Data Analysis Expressions (DAX) expression for the Is Undersell column.
Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)
A. =IF([Unit Sales Price]< RELATED(Products[Minimum Sales Price]), TRUE, FALSE)
B. =IF (RELATED(Products[Unit Sales Price])< [Minimum Sales Price], TRUE, FALSE)
C. =IF([Unit Sales Price])< LOOKUPVALUE(Products[Minimum Sales Price], Products[Product Id], [Product id]), TRUE, FALSE)
D. =IF(LOOKUPVALUE (Products[Unit Sales Price], Products[Product Id], [Product id])<[ Minimum Sales price]), TRUE, FALSE)

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.