Forum Discussion
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...
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:
you can use the function concatenate or simple put your values and use & to join them.
example:
measure name = concatenate("hello"," word")
