Hi. I have a Product_Master Table with columns [Product Code] and [Product Description]. Is there a version of the CONCATENATE() expression that I can use in the [Product Code] Column that will display both the [Product Code] and the [Product Description], something like
SELECT(Product Master[Product Code],TRUE,TRUE),
SELECT([Product Master[Product Description],TRUE,TRUE))
I am getting a data validation error with the above expression so that can’t be correct but if there was a way of achieving this it would be great.