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:

     

ashishrj's avatar
ashishrj
Icon for Power Participant rankPower Participant
8 years ago

Hi azizimranz you can create a measure and store your dynamic value into this (with your logic defined). Later you can use this measure to append it with some text data. For instance find below format on how it will goes:

 

Calculated Measure = "Environment is " & [Dynamics_Measure] 

 

Hope this helps !

  • 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.