Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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