How should you write the calculation?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used
in the definition of a hierarchy. The City column exists in the Geography table that is related
to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used
in the definition of a hierarchy. The City column exists in the Geography table that is related
to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

A.
City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])

B.
City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey])

C.
=RELATED(Geography[City]) =RELATED(Geography.City)

D.
=VALUES(Geography[City])

E.
City:=VALUE5(Geography[City])



Leave a Reply 6

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


Du

Du

Correct answer should be:

=RELATED(Geography[City])

Ralph

Ralph

Tablet arÄ™ related SO need to usesomething wlse

Ralph

Ralph

I meant… Tables are related, so solution from Du is correct. It is probably answer “C”

Andres

Andres

Tables are already related.
It`s C =RELATED(Geography[City])

Youri

Youri

C is Correct