Home » Microsoft » DA-100 v.2 » What should you recommend?
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
A. Split the model into multiple models.
B. Hide unused columns in the model.
C. Merge tables by using Power Query.
D. Transpose.
Correct Answer: C
Explanation/Reference:
Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query. When you have one or more columns that you’d like to add to another query, you merge the queries.
Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression. CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
C