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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Ashish_Mathur ,

 

Please refer to the attached pbi file. The dateset had been imported to the report. 

 

https://drive.google.com/file/d/1W3jj0nzmyL24LySgyHvMFHuSHJpXnvsf/view?usp=sharing

 

 

For the expected result, I wanted to add a new column to my schedule table with profile selected. The column shoud be the part no of the selected profile for respective model at each line. 

 

I hope below pictures can explain what  I wanted. Thank you for your time.

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

In the Schedule Table, write this calculated column formula

=Column = LOOKUPVALUE(Profile[PartNo],Profile[id],Schedule[ID])

Hope this helps.