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.
Hello Power BI expert community. Hope you all are doing great. I am facing a little problem to create relationship among the tables i am working with. Currently there is no relationship and I am unable to create one myself. It will be a great help if you can give advice regarding how I can create relatiionships across the tables I have. Here is the file I am working with.
https://drive.google.com/file/d/0B0XwYvmbIN12aVRwMmdXNlhXMVk/view?usp=sharing
A prompt solution will be highly appreciated. Thanks
Hi @Hasan_iba,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi @Hasan_iba,
Please check this file for details: https://1drv.ms/u/s!ArTqPk2pu-BkgSU2FAfyg2naW2Uo
1. Create a date table.
Calendar = CALENDARAUTO()
2. Create a table of all regions.
Regions = DISTINCT ( UNION ( VALUES ( Table1[RegionCode] ), VALUES ( Table2[RegionCode] ), VALUES ( Table3[RegionCode] ) ) )
3. Create a table of all segmentations.
Segmentations = DISTINCT ( UNION ( VALUES ( Table1[Segmentation] ), VALUES ( Table2[Segmentation] ), VALUES ( Table3[Segmentation] ) ) )
4. Establish many 1:* relationships.
Best Regards!
Dale
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |