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 correct answer is A. Merge tables by using Power Query. ). RELATED and RELATEDTABLE functions are needed in DAX to look up values from related tables across relationships. When you merge tables in Power Query, the related data is physically combined into a single flat table, eliminating the cross-table relationships that require…

Submitted by kwame.gh· Apr 18, 2026Prepare the data

Question

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?

Options

AMerge tables by using Power Query. )
BHide unused columns in the model. )
CSplit the model into multiple models.
DTranspose.

How the community answered

(46 responses)

A
72% (33)
B
9% (4)
C
17% (8)
D
2% (1)

Explanation

RELATED and RELATEDTABLE functions are needed in DAX to look up values from related tables across relationships. When you merge tables in Power Query, the related data is physically combined into a single flat table, eliminating the cross-table relationships that require RELATED/RELATEDTABLE calls. This simplifies DAX expressions significantly. Hiding columns (B) reduces visual clutter but does not affect DAX complexity. Splitting the model (C) would increase the need for cross-table references. Transposing (D) changes row/column orientation and is unrelated to relationship navigation.

Topics

#Power Query#Data Transformation#DAX Optimization#Data Modeling

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice