Pass parameter through SQL Statement in Power BI

[DavidWaters100]

Hi,

I am trying to pass a parameter through SQL Statement in Power BI.  I have seen some solutions similar to this question but couldn't quite adapt them so wanted to ask the question with my scenario.  Below is part of the DECLARE which I want to run the parameter ie not LON but the parameter chosen; beneath this is the parameter I have set up with the BRLocation values.

Trying to keep this simple, any help greatly appreciated!

DECLARE
(there are others)
,@BRLocation VARCHAR(255) = N'LON'

[amitchandak · Accepted solution]

Refer, if this can help

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/