cancel
Showing results for
Did you mean:
Frequent Visitor

Concatenate values ascending/descending by date/time

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:

Bests,

T

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

Re: Concatenate values ascending/descending by date/time

Hi @grafvont ,

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

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super Contributor

Re: Concatenate values ascending/descending by date/time

Hi @grafvont ,

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

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

Re: Concatenate values ascending/descending by date/time

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

Best regards,

T

Announcements

Back to School Contest

Engage and empower students with Power BI!

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 36 members 840 guests
Recent signins: