Concatenate values ascending/descending by date/time

[Anonymous]

Dears,

I'm trying to create a chain of values sorted by date/time, with the actual formula the ASC/DESC order apply on the value instead of the date/time, how can I do?

Chain Column = 
CALCULATE(
        CONCATENATEX(
            'Data';
            Data[Status];
            " - ";
            Data[Stauts];ASC
        );
        FILTER(
            ALL('Data');
            'Data'[OrderID] = EARLIER('Data'[OrderID])
        )
)

For example:

Thank you for your support!!!

Bests,

T

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

From your description, you want to create a chain of values sorted by date/time, could you have modified your formula as below:

Chain Column = 
CALCULATE(
        CONCATENATEX(
            'Data';
            Data[Status];
            " - ";
            Data[Date Time];ASC
        );
        FILTER(
            ALL('Data');
            'Data'[OrderID] = EARLIER('Data'[OrderID])
        )
)

And if it could not help you, could you please share your sample file to have a test if possible?

Regards,

Daniel He

[Anonymous]

Thank you Daniel! Is exactly what I was looking for!

Best regards,

T