Forum Discussion

aris's avatar
aris
Frequent Visitor
3 years ago
Solved

link alternate part numbers

Table A requested part number partno qty request A 10   Table B alternate partno partno  alternate partno A C   Table C ordered partno orderno partno qty PO1 A ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi aris 

     

    First add a custom step in Table B to transform it into the following format. 

    = Table.Combine({#"previous step", Table.AddColumn(Table.SelectColumns(#"previous step", {"partno"}), "alternate partno", each [partno])})

    Then create relationships:

    Table A (partno) 1-->* Table B (partno)

    Table B (alternate partno) 1-->* Table C (partno)

     

    Create a measure as a flag. Apply it to the second table visual as a filter and set it to show items when value is 1. 

    flag = IF(ISFILTERED('Table A'[partno]),1,0)

    I have attached a sample file at bottom. Hope it helps. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi aris 

 

First add a custom step in Table B to transform it into the following format. 

= Table.Combine({#"previous step", Table.AddColumn(Table.SelectColumns(#"previous step", {"partno"}), "alternate partno", each [partno])})

Then create relationships:

Table A (partno) 1-->* Table B (partno)

Table B (alternate partno) 1-->* Table C (partno)

 

Create a measure as a flag. Apply it to the second table visual as a filter and set it to show items when value is 1. 

flag = IF(ISFILTERED('Table A'[partno]),1,0)

I have attached a sample file at bottom. Hope it helps. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • aris's avatar
    aris
    Frequent Visitor
    3 years ago

    thank you so much v-jingzhang

    I am on holiday now, i will check it next week when back. it seems to be exactly what i need but will let you know 🙂 thanks again

     

    PREVIEW