Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Add New Column that query data from another table based on Slicer selection

Hi All,

 

Appreciate if you guys can help.

 

I have two tables:

1. Schedule Table

2. Profile Table

 

I would like to add additional column in my schedule table, based on the selection of the profile, to query the latest part no from my profile table for each model no and output the part no to the new column.

 

Schedule table with profile slicer:

Profile table:

this can be done in sql with join statement, but i want to integrate with slicer selection to output the part no. Please advise. Thank you.

 

Regards

 

Need Help

8 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    Is there a common column in both of your tables? If yes trying creating a relationship between these 2 tables.

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Pragati11 

       

      Yes I have created the relationship between this two tables. But the profile table contains duplicate records, so I would need to filter out the latest profile for that model no.

       

      With the slicer involved, do you know how to construct the dax? Please advise. Thank you.

       

      Regards.

       

      Jenas

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi All,

     

    Anyone can assist on this? Appreciate it!

     

    Regards.

     

    Jenas

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Please show a few rows of both tables and also show the expected result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Ashish_Mathur ,

       

      Thank you for the reply. Please find the following details:

       

      Schedule Table:

      Profile Table:

       

      I have schedule table which show the production schedule of model and profile table which store the part no for each model. Because each model have a few part no and each part no production line only require to see relevant part no. Hence, based on user selection of profile with the slicer, I want to show only the selected part no to the user.

       

      Example:

      When I choose 'Carton Box' from my slicer, it should query my profile table for the part no for each model no from my schedule table and add new column of part no for carton box only into my schedule table.

       

      Hope it clarifies. Thank you.

       

      Regards.

       

      Jenas

       
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        5 years ago

        Hi,

        I am still not clear.  Please share small dummy datasets (which are easy to read and understand) and on that, please show the expected result.  Also, share the link from where i can download your PBI file.