Hi all,
I am a newbie to Query Parameters and wanted to know if this was possible and the simplest way to do this.
I have a data source from Excel in my PBI Desktop. Let's say, for example, there is a column denoted "Column A" in this dataset.
I have another data source extracted from the latest .xlsx file in a folder (I've already established the code for this), but I'd like to filter the data pulled based on Column A in the other table.
I would like to set up a parameter to only pull in a row from this data source if that row has a value in a specific column that matches one of the values in Column A.
Here's a visual of what I mean:
Data Source #1:
| ID | Material | Qty |
| 12345 | AAA | 5 |
| 67891 | ABC | 10 |
| 13579 | BBB | 1 |
| 24680 | CDE | 3 |
| 00000 | CCC | 5 |
All of this data will be loaded in the PBI Desktop.
Data Source #2
| Routing Time | Material |
| 50 | AAA |
60 | XYZ |
| 40 | BBB |
10 | SUV |
20 | LMN |
The strikethrough values are NOT loaded into the table becauses the "Material" column does not match any value that is in the "Material" column of Data Source #1. How do I go about setting up this parameter?
Thanks,
Farhan
