Establishing multiple table relationships

Hi Anonymous

If you split tables before import data into Power BI, please ingore the words below.

How do you split one table to many tables, do you use Edit Queries or create a New table(Home ->New Table) with DAX?

If you use create a New table with DAX, please note the circle dependence problem.

please read this article to learn how to create relationship among tables

1. Date table

2.Population table

linked column: [date]

cardinality: one to many 

cross filter direction: both

1.Date table

2.Media table

linked column: [date]

cardinality: one to many

cross filter direction: both

1.Population table

2.Media table

linked column: [unique id]

cardinality: one to one

cross filter direction: both

Best Regards

Maggie