NEED HELP - working with TEXT

[Anonymous]

Hello Experts here, 

I need to solve this prob, but i'm stuck 😓 I hope to find some ideas/ solution here 

I have these 5 table, all are TEXT 

Here is result I'd like to archive.

there are 2 conditions: item must have under Country assortment then only check on Door class

Door	Item	Assortment	Can order Y/N
TH1	A2	Y	Y
TH3	A2	Y	N
SG1	B2	N	N

[v-kkf-msft]

Hi @Anonymous ,

I can't understand which tables the result that you want to achieve comes from, and what are the implications.

And I don't understand what this sentence means? Could you please explain in more detail?

---

@Anonymous wrote:

there are 2 conditions: item must have under Country assortment then only check on Door class

---

Best Regards,
Winniz

[amitchandak]

@Anonymous , You have unpivot the assortment by class and assortment and then do the joins.

https://radacad.com/pivot-and-unpivot-with-power-bi

Can you share sample data and sample output in table format?

[Anonymous]

Hi Chandak,

I done unpivot tables, but i could not connect Item master to Assortment table 

PREVIEW

[amitchandak]

@Anonymous , On the first screenshot, I saw Customer master has country and door and you do not have a door assortment even after unpivot, that will give many many by direction, in such case we either as a column with min door not in fact or use a separate county table  

new column in assortment

minx(filter(customer, customer[country] = assortment[country]),customer[door])

this will enable 1-M join between two one direction, after that try to enable the item join , it should work