Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 would have ...production...
I need to set a custom column having a concatination of some hardcoded text with 'this dynamic server environment'
Any way of reading the system properties in powerbi, or reading another database table's value in other table and using that value in a function showing custom column?
Solved! Go to Solution.
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:
Hi,
Show a sample dataset and the expected result.
Hi,
There is no relationship between those two tables.
Take one table having all the data, and other table having a single constant value.
I want to display the table having all the data, along with the concatination of that constant field in one of the custom columns, (off course for every record).
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:
Thanks a lot @MarcelBeug
It works!
Here is my implementation:
let
Source = Sql.Database(SQLServer, Database),
dbo_test_table = Source{[Schema="dbo",Item="test_table"]}[Data],
#"Added Custom" = Table.AddColumn(dbo_test_table, "Environnment and Server from Table B", each Table.First(#"system_properties")[value]),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Environmemnt and Server from parameter", each Server)
in
#"Added Custom1"
It looks you implemented both alternatives instead of chosing one of the 2 (either a parameter or a table with 1 value).
Hi @MarcelBeug
Yup I know, its just a testing work. Works well. Thanks
There is one another issue, if you can help me out in it please. See this
you can use the function concatenate or simple put your values and use & to join them.
example:
measure name = concatenate("hello"," word")
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 !
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |