Need to summerize please- all sandwitch salads belong to same day . how to combine all in to one row

[AIwithBI]

Please, help
looking for all in one row dax function ( calcullated table)
all Sandwitches Salad belong to same day how to combine to one row? Please, Thanks 

[v-kkf-msft · Accepted solution]

Hi @AIwithBI ,

Please click Transform -> Group By. The Group By dialog box will open. Then calculate the maximum value for [Sqnwitch salads] column.

Then edit the M code in the formula bar.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AIwithBI]

Looking for solutions to combine multiple rows within the same day into a single row into something like below, is this doable using power query or DAX 

[AIwithBI]

@tamerj1  Thank you, concatenatex wont stop from specific date. It's keep adding entire column. 

Would you please help me to stop from specific date?

Thanks 

[tamerj1]

Hi @AIwithBI 

Use CONCATENATEX. If you can provide more details I may help you out.