cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
grafvont Frequent Visitor
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:

 

2019-03-08_15-45-04.jpg

 

Thank you for your support!!!

 

Bests,

T

1 ACCEPTED SOLUTION

Accepted Solutions
v-danhe-msft Super Contributor
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])
        )
)

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

 

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
v-danhe-msft Super Contributor
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])
        )
)

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

 

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.
grafvont Frequent Visitor
Frequent Visitor

Re: Concatenate values ascending/descending by date/time

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

 

Best regards,

T

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

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

Top Ideas
Users Online
Currently online: 36 members 840 guests
Please welcome our newest community members: