Forum Discussion

Bhavana_PB's avatar
Bhavana_PB
Frequent Visitor
8 years ago
Solved

Invalid Identifier error

Hi All,

 

I have created a parameter using manage parameter option form edit queries. But I want to call that parameter in a measure, so I created a blank query and I am trying write this syntax 


As you can see I have named my parameter on right hand side as "Select Measure"
so when I write a syntax in blank query like this 
let
Source = #table({“MeasureParameter”},{{#”Select Measure”}})
in
Source

It gives me Invalid Identifier error. over this section 


I have no idea what is happeneing, My actual parameter is on right side of syntax, so what is first part which I have highlighted?
I think its just a random name by which that parameter will be called.. I need help on this..

I am following this article
http://community.powerbi.com/t5/Desktop/Passing-Parameters-in-measures/m-p/208276

Thanks in advance.

  • Hi Bhavana_PB,

     

    Please try it like this. I would suggest you avoid using spaces in the parameter names. Then you can use the parameter name directly.

    let
        Source = #"Select Measure"
    in
        Source

    Invalid_Identifier_error

     

    Best Regards,

    Dale

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Bhavana_PB,

     

    Please try it like this. I would suggest you avoid using spaces in the parameter names. Then you can use the parameter name directly.

    let
        Source = #"Select Measure"
    in
        Source

    Invalid_Identifier_error

     

    Best Regards,

    Dale

    • Bhavana_PB's avatar
      Bhavana_PB
      Frequent Visitor

      Hi,

       

      Sorry for late reply, yes its working for me.

      Thank you
      Bhavana