Forum Discussion

azizimranz's avatar
azizimranz
Frequent Visitor
8 years ago
Solved

How to concatinate text with some dynamic value

Hi All,   My scenario is, need to show a url hyperlink icon based on the environment. i.e. if the environment is staging, url would have ...staging..., and if the environment is production, url wou...
Need Help
Show and Tell
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    You can also choose for a Power Query solution (Query Editor).

    If you only have a single value, you can also define a Parameter.

     

    Example query code with both alternatives:

     

    let
    Source = #table(type table[Environment = text],{{"Env 01"},{"Env 02"}}),
    #"Added Custom" = Table.AddColumn(Source, "Environnment and Server from Table B", each [Environment] & " " & Table.FirstValue(#"Table B")),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Environmemnt and Server from parameter", each [Environment] & " " & Server)
in
    #"Added Custom1"

     

    Screenshot for parameter definition:

     

azizimranz's avatar
azizimranz
Frequent Visitor
8 years ago

Hi ashishrj

 

There are two tables I have imported:
Table A: contains all the data
Table B: contains only one row with single column having server name in it.

I have created a measure on Table A, which is getting the server name from Table B
Now when I create a custom column on Table A, I cannot use that measure in it. say like = "Environment is " & [measure_name]


Please let me know where I am wrong.

emadrigal's avatar
emadrigal
Icon for Helper II rankHelper II
8 years ago
verify that you have relationship many to one and both direction. instead of using a measure you can create the cistom column directly.