How to call parameter inside the table

HI Poojajunnu 

your request is unclear, please specify what you mean by parameter, what you mean by calling inside a table

Solved Community Threads

🔗Parameters in Power BI (show measure based on a parameter) – solved link from Microsoft Fabric Community
➡️https://community.fabric.microsoft.com/t5/Service/Parameters-in-Power-BI/m-p/2414024/SOLVED (use a separate table with measure names and slicer) Microsoft Fabric Community

🔗Bind to parameter missing / using dynamic M query parameters
➡️https://community.powerbi.com/t5/Desktop/Bind-to-parameter-is-missing-in-modelling-advanced-properties/td-p/2255295 (explains how binding works and limitations) Power BI Community

🔗Call two different measure parameters in DAX
➡️https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/call-two-different-measure-parameter-in-DAX/m-p/3472672/SOLVED (solution shows how to structure parameter table with group logic) Microsoft Fabric Community

🔗Power BI Edit Parameters (using What-If Parameter)
➡️https://community.fabric.microsoft.com/t5/Power-Query/Power-Bi-Edit-Parameters/m-p/4421411/SOLVED (shows how to use a What-If parameter in report via slicer) Microsoft Fabric Community

🔍Additional Community Related Resources

You can search the main Power BI forums for more parameter solutions:
➡️https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi

I hope this helps!
If you found this answer helpful:

Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member!

It seems to be that you're trying to call the value of a what-if parameter from a slicer inside a calculated table. If this is the case, unfortunately, calculated tables are not aware of slicer selections so they don't know what value is selected in a slicer. Calculated tables are computed only upon creation, when the underlying data (not a slicer selection)  has changed or upon refresh.

Hi Poojajunnu ,

The answer depends slightly on whether you are in Power Query (M) or DAX, but assuming you want to use a Query Parameter to filter or modify a table in the Power Query Editor, here is how you do it.

Scenario 1: Filtering a Table by a Parameter (The Easy Way) You don't need to write code for this. You can use the UI.

1. Go to the column you want to filter.

2. Click the Filter arrow > Text/Number Filters > Equals...

3. In the dialog box that pops up, click the little "ABC" or "123" icon on the right side of the input box.

4. Select "Parameter" from the dropdown.

5. Choose your parameter name. Power BI will automatically write the M code: Table.SelectRows(Source, each ([ColumnName] = MyParameter))

Scenario 2: Adding a Parameter as a New Column If you want to add the parameter value to every row in your table:

1. Go to Add Column tab > Custom Column.

2. In the formula box, simply type the exact name of your parameter.

   • Example Formula: [Revenue] * MyExchangeRateParameter

3. Power Query treats the parameter as a global variable, so you can call it by name anywhere.

Scenario 3: Inside a Native SQL Query If you are writing a SQL statement in the "Get Data" window: You cannot just type the name. You have to concatenate it into the text string.

• Example: "SELECT * FROM Sales WHERE Year = " & Number.ToText(YearParameter)

Let me know which specific scenario you are trying to achieve!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.