Concatenating value from the previous row

[WOLFIE]

Hi,

Could you please help to amend this measure to concatenate text rather than integers? Thank you

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

I have created sample data and how it should look like. I need it concatenated with each new date and value, but only for group A. The measure doesn't work.

[amustafa · Accepted solution]

Here you go...

ConcatDescriptions = 
VAR CurrentDate = 'Table'[Date]
VAR FilteredTable = FILTER(
    ALL('Table'),
    'Table'[Group] = "A" && 'Table'[Date] <= CurrentDate
)
RETURN
IF(
    'Table'[Group] = "A",
    CONCATENATEX(
        FilteredTable,
        'Table'[Description],
        ", "
    ),
    BLANK()
)

[WOLFIE]

@amustafa Thank you so much! 🙂

[amustafa]

Try this...

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

[WOLFIE]

Thank you @amustafa. Unfortunately this doesn't work I have created sample data and how it should look like