Forum Discussion

majid_75's avatar
majid_75
Icon for Helper I rankHelper I
4 years ago
Solved

DAX concatenatex or path

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

CONCATENATEX
DAX
  • majid_75's avatar
    majid_75
    4 years ago

    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]))

3 Replies

  • majid_75's avatar
    majid_75
    Icon for Helper I rankHelper I
    4 years ago

    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's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    4 years ago
    View Page =
    CALCULATE(
    CONCATENATEX(SUMMARIZE('Table','Table'[Chemin],'Table'[Id]),'Table'[Chemin],",",'Table'[Id]),
    ALLEXCEPT('Table','Table'[Id])
    )
    • majid_75's avatar
      majid_75
      Icon for Helper I rankHelper I
      4 years ago

      Hello,
      Thanks but i have the same issue