Relationship by duplicate ID

[Anonymous]

Hi there,

Could somebody kindly tell me if its possible to replicate a dimensions ID (Building ID) into a fact table based on the exact name (Building Name) for each row of the fact table?

Fact Table

Building Name

Booking Date

Booking ID

Booking Time

Building (Dim)

Building Name

BuildingID

Thanks

Liam

[SivaMani · Accepted solution]

@Anonymous 

Please do check this DAX function - https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

[Anonymous]

Thankyou @SivaMani  🙂