How to connect data with Relationship

[Kamaizziati]

Hi All,

I have question, can we connect the data betweet two column without using relationship.

I have table REVENUE and PBT but I cannot create the relation betwwen this two table because of the duplication data. 

But its connect to Company name on Company Table.

I want to combined this two table data in one dashboard and using Date filter by revenue data.

Now when i select the data filter, the PBT data connot filter by that because data filter is from Revenue Data.

How can I connect the REVENUE and PBT because the date data is same but its duplicate.

Thanks

[Anonymous · Accepted solution]

Not sure how was your data structure. Did you try to create the following relationship? Linked the date from PBT/Revenue to Calendar table. The calendar table contains unique date information so it can be used as a bridge to create relationship between PBT and Revenue.

[Anonymous]

Do you want to filter data based on date? If this is the case, try to create a specific calendar table and then link it with the REVENUE and PBT tables. Then use the date info from calendar table for flitering.

Hope it helps

[Kamaizziati]

@Anonymous,

I already do like your suggestion but I cannot connect relation to both PBT and REVENUE due to the PBT and REVENUE already connect to COMPANY table.

Thanks

[Anonymous · Accepted solution]

Not sure how was your data structure. Did you try to create the following relationship? Linked the date from PBT/Revenue to Calendar table. The calendar table contains unique date information so it can be used as a bridge to create relationship between PBT and Revenue.

[Kamaizziati]

Hi @Anonymous,

How do yo do that because I cant.

See below figure.

Thanks

[v-yuezhe-msft · Accepted solution]

@Kamaizziati,

Change cross filter direction of your relationships from Both to Single, then check if you get expected result as Jessica_Seiya descibed.

Regards,
Lydia

[Kamaizziati]

Hi @Anonymous,

How do yo do that because I cant.

See below figure.

Thanks