CONCATENATE DAX function not recognized in Custom Column Window

Hi Anonymous ,

Microsoft Power BI supports two different languages, M language(in Power Query) and DAX .

CONCATENATE() function is used for DAX not for M.

So if you could use the following to get the same effect:

    #"Grouped Rows" = Table.Group( #"Changed Type" , {"Cate"}, {{"Custom", each Text.Combine([Value], "/"), type text}})

Table 2 =
ADDCOLUMNS (
    VALUES ( 'Table (2)'[Cate] ),
    "Product",
        CALCULATE (
            CONCATENATEX ( VALUES ( 'Table (2)'[Value] ), 'Table (2)'[Value], "/ " )
        )
)

My final output looks like this:

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin