Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous
Please do check this DAX function - https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
@Anonymous
Please do check this DAX function - https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |