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.
A prompt solution will be highly appreciated. Thanks
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.
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.