- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Create parameter for different columns and get value from different columns
How can we pass parameter values from a different column but in the query I pass values from another corresponding value in another column and do calculation. So for ex: I have two columns Id and Name. I crreate a list of Ids and create a parameter for it. Now when I select Id , I would like the value in the Name column for that corresponding ID to be passed in my Power Query. Is it possible?? How??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @PowerrrBrrr
Not sure I completely understood your issue. But I think in Power Query you just have to merge the two queries by the id and then expand the column you want and finally do your calculation. In Power Query to do calculations you need to have the data in the same query.
Please accept it as a solution if it solved your issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Not sure I understand your solution but thats maybe you didnt get my question. So here I go again:
I have a table with something like this:
Id | name | value |
1 | aaa | ohcsjachacaxalkcjalkjcxax |
2 | www | sackljdadmcmansciajcackjhacs |
And I have a Parameter where the Parameters are defined on the as Query type with Ids from above table. So when I open my file I get parameter to select the "Id" from a drop down and based on Id value the report gets filtered. And I also have a power Query in my model which needs [Value] column to be passed. And Now Thats my question that how can I send the [Value] to my power query based on the Id selected as a parameter.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-21-2023 11:27 PM | |||
Anonymous
| 06-04-2024 07:39 AM | ||
07-18-2024 12:30 PM | |||
08-05-2024 11:21 AM | |||
04-18-2024 12:20 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |