CODEWITHSUNDEEP
powerbidax
Sebastian Hubard
Sebastian Hubard

Reputation: 163

Why can't I pull a "Related()" column from another table in Power BI?

I currently have two tables:

Email Jobs: has several columns on email jobs such as a Send ID and Sent Time

Send ID: a unique list of all Send ID's coming from the "Email Jobs" table

I'm trying to pull the Sent Time column from the "Email Jobs" table into the "Send ID" table but the following function doesn't register the column (the column and table name show up in light grey)Formula Relationship Relationship Conditions Any help would be much appreciated.

Upvotes: 2

Views: 9523

Answers (1)

CR7SMS
CR7SMS

Reputation: 2584

You will be able to use RELATED function directly only if it is a "one to one relationship". If it is a "many to one" relationship, then you might have multiple values for the same record. In this case you will have to use RELATEDTABLE function and aggregate the values. The following link explains the basics of this function:

https://learn.microsoft.com/en-us/dax/relatedtable-function-dax

The following calculation might work in your scenario:

Calc = MAXX(RELATEDTABLE('Id Send Jobs'),[SentTime])

Hope this helps.

Upvotes: 3

Related Questions