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 wi...
Need Help
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