Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
yishenhui
Helper I
Helper I

How to control the order when grouping

Hi,

 

When I grouping, is it poosible to control the order of aggregation? As below two screenshots, the first step, the data is already sorted. But when I grouping and want to combine those string together with this order, it doesn't. Any idea how to get it?

 

Thanks

 

image.pngimage.png

1 ACCEPTED SOLUTION
Payeras_BI
Super User
Super User

Hi @yishenhui ,

I would try this:

Table.Group(Table.Buffer(SortTableAgain),...

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

2 REPLIES 2
Payeras_BI
Super User
Super User

Hi @yishenhui ,

I would try this:

Table.Group(Table.Buffer(SortTableAgain),...

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

Hi J.Payeras,

 

I applied a sorting  in the source date loading. After that, the issue disappeared even I removed the sorting. I cannot re-produce the issue again to test your suggestion. But I have read the articles about Table.Buffer and would accept it as Solution.

 

Thanks.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors