Tabular Model

[sudarshan]

Budget Table		Associate Table
Budget		Associate Id
Date		State
State
Lender

I want to be able to join the Associate table and the Budget table based on state.

In MDM you can set the relationship type as regular and it works like a charm. In a tabular model, as the states are repeated more than once it is not letting us create a relationship between them.

any thoughts on how to resolve this?

[v-chuncz-msft]

@sudarshan,

You may add a calculated table and then build relationships.

http://community.powerbi.com/t5/Desktop/Cannot-create-relationships-Power-BI-finding-duplicates-that...

[sudarshan]

Thanks for this. I will give this a shot.