Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to pass parameter with in created column by using DAX

Hi,

 

Here is the details of what i am looking for and need your inputs.

 

i am using one column url_check="https://hyperlink1/user"= & min(table[userid])

as per the need i am passing user id with in hyperlink and the above url is going to change for diffrent environments.

so i have created parameter and trying to pass diffrent urls through parameter value.

 

parameter name is URL_param, type as text and current value is above hypelink..

 

after that iam trying to pass parameter "URL_param" in my column as below.

 

url_check=URL_param & min(table[userid])

but the parameter "URL_param" is not able to assign and i am getting error as parameter is not recognized.

 

so, please suggest how to pass parameter in existing column  and provide your inputs.

Thanks for your help in advance.

 

Thanks,

Mahi1827

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , If you have a user id in your table you can use it

    A new Column  like

    url_check=URL_param & (table[userid])

     

    You can not use a measure into a calculated column

     

    or a measure like

    url_check= max(URL_param) & Min(table[userid])

     

    This will work correct on the line level row context

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak,


      Thanks for your time..

       

      I have tried by creating measure url_check= max(URL_param) & Min(table[userid]) but still parameter URL_param is not recognized in both calculated column and measure.

       

      parameter deatils are parameter name is URL_param, type as text and current value is "https://hyperlink1/user"= (sample link)..

      actually some other parameters are recognized when applied from advanced query editor properties for any specific table  but in my case i am passing heper link used in user id column this calculated  column is used in table visual.

       

      So as per need when click on user id it navigate to diffrent urls it should fetch from  parameter. so its mandatory i need to pass diffrent urls in given parameter.

       

      so please suggest any alternative methods and any solutions to get result.

      Thanks for your help in advance..

       

      Thanks,

      Mahi1827

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    I can't reproduce your issue and it works well.

     

    Please share us a dummy .pbix file with the same issue for test. And don't forget to remove sensitive information.

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.