Forum Discussion
Solved
funcion concatenate
I want to use the CONCATENATE function but when I put it I do not see the table with the data that I want to concatenate. I get just one of the boards. How can I check out data from any table?
Hi pabloschmidt ,
I see you are using directly mode. Check the document.
https://docs.microsoft.com/en-us/dax/concatenate-function-dax#remarks .
It says "This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules."
Remarks
-
The CONCATENATE function joins two text strings into one text string. The joined items can be text, numbers or Boolean values represented as text, or a combination of those items. You can also use a column reference if the column contains appropriate values.
-
The CONCATENATE function in DAX accepts only two arguments, whereas the Excel CONCATENATE function accepts up to 255 arguments. If you need to concatenate multiple columns, you can create a series of calculations or, better, use the concatenation operator (&) to join all of them in a simpler expression.
-
If you want to use text strings directly, rather than using a column reference, you must enclose each string in double quotation marks.
-
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Best Regards,
Jay
-
Adjunto dos imagenes. En una se pueden ver todas las tablas disponibles y en otra las que me aparecen cuando busco con la funcion CONCATENATE. No entiendo por que solo me aparecen algunos elementos y no me deja buscar entre la totalidad de las tablas. No sé si hay alguna forma de tomar valores de cualquier tipo de tabla.