Creating an efficient semantic modeling

[sivarajan21]

Hi

I need your help in creating a semantic modeling for the below tables:

I have below 7 tables and their names are:

Unify Budget

Unify Meter Location

Unify Budget Output

Bridging Table

EM DataElectricity

EM Misc Charges

EM Contacts

EM Points

Now above set of unify tables needs to connected with EM set of tables through the Bridging table.

Could you please help me with that sir?

PFA file here Example Extract.xlsx

Thanks in advance!

@marcorusso @Ahmedx @Greg_Deckler @amitchandak 

[v-jianpeng-msft · Accepted solution]

Hi, @sivarajan21 

I looked at your example file and you should use the ID column of the bridge table to connect to the corresponding ID column of the other table. Your relationship should be one-to-many or many-to-one, avoiding one-to-one and many-to-many. Here's a view of possible relationships:

You should understand what a relationship means and what it does:

It is recommended that you read the following articles to understand the background of the relationship and then build an appropriate relationship according to your actual needs. In your bridging table, the ID field may be a good connection key.

Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified - RADACAD

What is the Direction of Relationship in Power BI? - RADACAD

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI - RADACAD

In addition, you may also need a date sheet. You can use DAX expressions to create a date calculation table so that you can filter the data by date later.

Benefits of using a calendar table in Power BI - Data Bear - Power BI Training and Consulting

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sivarajan21]

Hi @v-jianpeng-msft ,

Many thanks for your solution!

This works and i will accept this as a solution