Forum Discussion
stefantaust
Helper I
Helper Iconcatenate a filtered column
Hello, I have two tables that aren't linked. How can I concatenate a filtered column from each table to create a new table with a column containing the result. e.g., k30307599999 Thanks, Stefa...
Hi stefantaust ,
The filter context that you are giving in the report page can't transfer to table view where you create a new table. What you can do is create a measure that concatenate these two fields together and returns the value for example:
SELECTEDVALUE('Table'[Name]) & SELECTEDVALUE(Parameter[Parameter])Giving the following output:
Demert
Resolver III
Resolver IIIHi stefantaust ,
The filter context that you are giving in the report page can't transfer to table view where you create a new table. What you can do is create a measure that concatenate these two fields together and returns the value for example:
SELECTEDVALUE('Table'[Name]) & SELECTEDVALUE(Parameter[Parameter])
Giving the following output: