Forum Discussion
Relationship by duplicate ID
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
Anonymous
Please do check this DAX function - https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
2 Replies
SivaManiResident Rockstar
Anonymous
Please do check this DAX function - https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Thankyou SivaMani 🙂