DAX concatenatex or path

[majid_75]

Hello,

I need help, please.
I have a table and I want to create a new column to concatenate the different pages of an ID according to the index.
The objective is to be able to trace the navigation of a user.

Here is my dax but I have an order problem on my new column

View Page =

CALCULATE(

CONCATENATEX(VALUES('Table'[Chemin]),'Table'[Chemin],","),

ALLEXCEPT('Table','Table'[Id])
)

I don’t understand what my mistake is.
Thank you

[majid_75 · Accepted solution]

Hello,

I think it's ok with my dax. I add a parameter in the function Concatenatex:

CALCULATE(

CONCATENATEX('Table','Table'[Chemin],",",'Table'[Index],ASC),

ALLEXCEPT('Table','Table'[Id]))

[wdx223_Daniel]

View Page =

CALCULATE(

CONCATENATEX(SUMMARIZE('Table','Table'[Chemin],'Table'[Id]),'Table'[Chemin],",",'Table'[Id]),

ALLEXCEPT('Table','Table'[Id])
)

[majid_75]

Hello,
Thanks but i have the same issue