Need help for tables

[Anonymous]

Hi , please help me for this simplified problems

Basically i would like, if people choose PP32016 in the slicer, the column shows abc, refer to image 2.

and ip people choose PP562018 in the slicer, the column shows bcd, refer to image 2

I find out that power BI doesnt let you have 2 active relationship from 1 table to 2 tables that have partially same information

Can you help me with this?

Image 2 shows from left to right table 1 , 2 , and 3

the lower table is table 4

THank you

Regards,

Elvin Luvian

DashboardTable 1 , 2 , 3 and 4my relationship

[amitchandak · Accepted solution]

@Anonymous , I would recommend you append tables or rules, proyek

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

You can refer to my Video : https://youtu.be/KyXIDInZMxk

[vivran22]

Hello @

[vivran22 · Accepted solution]

Hello @Anonymous ,

You may combine the two Rules table by using Append Query in Power Query:

Then you will not require any additional table to bring it in the model.

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[amitchandak · Accepted solution]

@Anonymous , I would recommend you append tables or rules, proyek

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

You can refer to my Video : https://youtu.be/KyXIDInZMxk