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