Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX How To Dynamically Concatenate Earlier Row Values

I would like to, using DAX because my table will be filtered dynamically and have different ModelNumbers each time, come up with a way to produce a concatenated list (comma deliminated) of all Val1 r...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Anonymous

     

    I just normalized the ModelNumber into a dimension table that is why you see it as another table

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Anonymous

 

Not sure if you are after something like this?

 

 

=
IF (
    HASONEVALUE ( 'Models'[ModelNumber] ),
    CONCATENATEX (
        FILTER (
            ALLSELECTED ( 'Models'[ModelNumber] ),
            'Models'[ModelNumber] <= SELECTEDVALUE ( 'Models'[ModelNumber] )
        ),
        CALCULATE ( SUM ( Data[Val1] ) ),
        ", "
    )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the fast response. Your example is exactly what I am looking to do. My results outputs are not the same as yours. The only difference I see is all my data is coming from the same table, and you have the values coming from the data table as an example. What am I doing wrong?

     

    See Concatenation is not working like yours

     

     

    • LivioLanzo's avatar
      LivioLanzo
      Solution Sage
      7 years ago

      Anonymous

       

      I just normalized the ModelNumber into a dimension table that is why you see it as another table

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks For Your Help! Working with the Formula and dim table suggestion.