Created Calculated Column based on a string of relationships

Anonymous — Mon, 06 May 2019 16:32:02 GMT

Hi,

I want to create a calculated column called Division Name in my Booking table. I need the Division Name to appear in this table for reasons that would take a while to explain. Anyway the Booking table has a BookingID that has a relationship to the Order table that also has the BookingID. The Order Table has a relationship to the Division table through the Division ID. I am trying to figure out how to write the calculated column expression. Here are the relevant column and table names. Can someone help? Thanks,

Division Name = LOOKUPVALUE(
Division[DivisionName],

Booking[BookingId],

Booking[OrderId],
Order[OrderId],

Order[DivisionId]
Division[DivisionId]
)

Re: Created Calculated Column based on a string of relationships

parry2k — Mon, 06 May 2019 18:28:42 GMT

Anonymous read this post to get your answer quickly

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

topic Re: Created Calculated Column based on a string of relationships in DAX Commands and Tips

Created Calculated Column based on a string of relationships

Re: Created Calculated Column based on a string of relationships